Report on Analysis and Design

Added on - 03 Dec 2019

  • 24

    pages

  • 6051

    words

  • 105

    views

  • 0

    downloads

Showing pages 1 to 6 of 24 pages
DATA ANALYSIS ANDDESIGN
TABLE OF CONTENTSINTRODUCTION.................................................................................................................................1LO1.......................................................................................................................................................11.1 Comparison between Data Models and Schemas.........................................................................11.2 Benefits and Limitations of Different Database Technologies.....................................................41.3 Different Approaches to Database Design...................................................................................5New developments............................................................................................................................6TASK 2.................................................................................................................................................82.1 Designing of a relational database for Hot Property....................................................................82.2 Build a relational database system based on a prepared design...................................................8.........................................................................................................................................................102.3 Techniques that helps in enhancing user interface.....................................................................13LO3.....................................................................................................................................................133.1 Benefits of using manipulation and query tools in a relational database system........................133.2 Query language into the relational database system...................................................................13TASK 4...............................................................................................................................................154.1 Critically review and test the relational database system...........................................................154.2User documentation for the relational database system.............................................................154.3Verification and validation of database tables...........................................................................154.4 Control mechanisms used in system development.....................................................................16I have taken the screen shot quarry from SQL which has been link to Ms Access..............................17I have taken the screen shot query from Ms Access showing the query..............................................19CONCLUSION...................................................................................................................................21REFERENCES....................................................................................................................................22
INTRODUCTIONOne of the most essential tasks of any organization nowadays is to maintain the dataof their customers as well as employees. In this respect, business database is considered as amost important technique by which through which any information system can be easilydevelop. The present report is based on the data analysis and designs in which variousdatabase techniques as well as approaches are taken into consideration for the company HotProperty. They are the small estate agent business in South Manchester. The companyoperates its business in the following way. Information is kept on sellers and maintained withall the present entities. Further, this study presents the relational database system for HotProperty and how they can manage the whole data about their property (Patra and Pradhan,2005). It provides proper knowledge about the database system including design principles,practical implementation as well as its development. Database tools and technologies areconsidered to be a most important and effective technique through which companies caneasily manage any type of data more appropriately. Further, this study gives propercomparison between data models and schemas as well as various benefits and limitations ofusing these types of systems. Moreover, designing of relational database as well asdevelopment of database designs is being presented in the study.LO11.1 Comparison between Data Models and SchemasA collection of conceptual tools for describing data are known as data models. It canalso be define as a logical design of data as well as relationship between different data parts.Data model represents a proper structure with connectivity on different entities, attributes aswell as relationship (Gillenson, 2008). The difference between data models and schemas canbe clearly presented:A data model defines as an abstract representation of data where schema is physicalentities that are captured in a printed document. Database schema is a blueprint that clearlypresents all those fields which are needed to be present. It helps in defining that how differentdata in database can be managed. Further, it is divided into database tables with the supportof any type of formal language.There are mainly three types of data models i,e.Hierarchal data model:This model represents data as a hierarchical tree structure inwhich each branch represents a number of related records. For this type of structural1|P a g e
representation data models depicts each record only once and uses a line between a parentrecord and its children. It shows connection between them.Relational data model:relational model directly presents data as a relation. All thedata records were connected by using logic and by using the data as well. Records on a givensubject occurrence could be easily selected from multiple tables. From this model whole datacan be accessed in many different ways without recognizing the database tables.Network data model:In this type of data model there is no implicit hierarchicrelationship between the various records. It may have many different records which mightcontain unique identifiers. It clearly represents data as a record type and also represents alimited type of one to much relationship.Data schema is a part of data model which mainly stands for shape or a plan. It isquite essential to differentiate between database as well as description of database. The totalrecord of any company which is being presented in the computer system defines as a datamodels (Sudarshan, Korth and Sileberschatz, 2011). In database schema it is quite easy to dominor changes such as adding a new field in a table. In order to do so it is not necessary tochange the whole program as it supports only one single table changes also. On the otherhand, this same case is not associated with the separate file for any type of any changing(Difference between database model and schemas,2015). Data models directly provide aframework which determines that what the software must be able to handle. Further, it can be2|P a g e
defined that both data models and schemas belongs to same database field but the process isentirely different in some cases.There are mainly two types of database schemas such as:Logical schema:It can be define as an initial data model of any user. It is made up ofactually what users have planned and its objects are table-spaces, packages, views etc. This isdesign centric database structure that is built to meet up all the business requirements.Physical schema:Under this place, there is a total storage of all the data files, redofiles, and control files that resides in row state. These objects make our data more readable. Itis actually a place what is implemented by the DBMS.Conceptual schemas:It is a model of database schema which is used as the semanticsof organizations and represents a series of assertions about its nature.Database Views:Within any database schema view is a tailored presentation of datathat contained in one of more tables or other views. It mainly takes output of a query andtreats it as a table. Further, view can be defined as a virtual table and it can be used all thetime where database schema is maintained. Example of database schema can be given below:Table field’s relationship:As per the viewpoint of schema there are mainly three types oftable relationship i.e.One-to-many:This relationship exists between only two entities such as: customertable and order table. It is a tracking database where customer can place any numberof orders and all these orders are presented in order table. It takes a primary key onone side of relationship and adds additional fields to the table on the many side ofrelationships.3|P a g e
Many-to-many:It can be define by the relationship with product table and order table.In this, a single order can include more than one product.One-to-one relationship:In this type of relationship, only a single match of eachrecord in another table can exist. Each record in the second table can have only onematching record in the first table.Different database languages which might use in data schemas such as:DDL:It is define as a data definition language in which different statements are usedto define the database schema. It can describe as a part of database schema through whichseveral objects are created and changes can be made within this. In addition to thisDML:It can be define as a data manipulation language in which different statementare used for managing data within scheme objectives. Under this, user can select data as wellas insert and update any type of data within the tables.1.2 Benefits and Limitations of Different Database TechnologiesThere is wide range of database technologies used by different firms. All of thesetechnologies are having different benefits as well as limitations. Some of the major benefitsof using this technique are as follows:Data consistency:At the time of updating any data item once, DBMS automaticallyupdates each occurrences of a data item (Graham, 2012). Now, it will be automaticallyavailable to all its users and they can easily control the total data redundancy.Controlling data redundancy:There are different application programs that are runningon same system. All of them are having their own files and still some duplicate files arecreated at many places in non-database system. By having proper database system all the filescan be stored at only one place and there is no any other duplicate copy of it. With this, dataredundancy can be removed completely and with the help of this, user can save storagecapacity.Data sharing:It is considered as a major benefit of using database technique in whichdata of same database can be easily shared between different application programs (Narang,2011).Data security:This is consider as a major benefit of using any database technique as itprovides several facilities through which security of data can be maintained. It clearlydetermines that only an authorized user can access the data from the database. At the time ofusing any DBMS system there are different usernames provides to each user with someprotected passwords as well.4|P a g e
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document