logo

Data Analysis and Design Assignment

7 Pages1464 Words274 Views
   

Added on  2019-12-03

Data Analysis and Design Assignment

   Added on 2019-12-03

ShareRelated Documents
DATA ANALYSIS AND DESIGN
Data Analysis and Design Assignment_1
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................11.1 Critically comparing different data models and schemas.................................................11.2 Critically discussing the benefits and limitations of varied database technologies..........21.3 Analyzing varied approaches to database design.............................................................3CONCLUSION................................................................................................................................5REFERENCES................................................................................................................................6ILLUSTRATION INDEXIllustration 1: Top down design.......................................................................................................3Illustration 2: Bottom up designing model......................................................................................4
Data Analysis and Design Assignment_2
INTRODUCTION Data analysis and design helps in creating foundation for the purpose of delivering BIapplication (Jonathan, 2008). By conducting data analysis business need of data and informationcan be understood. Likewise, by using design approach business information needs can beconverted into data structure which is extensible and adaptable. This report will provide detaileddescription regarding concepts that are associated with data models and database technologies. TASK 1 1.1 Critically comparing different data models and schemas A comparison has been drawn between different data models and schemas which aredepicted in below given table:DATA MODELDATA SCHEMAS Data model arranges data element and formsrelationship between them. This model is usedby the organization with an aim to manage allits information. It is the blue print of data structure whichbasically represents the logical of entiredatabase. It is the high level design implementationwhich helps in making the about the data thatcan be presented in schemas (Differencebetween database model and schemas, 2015). However, in comparison to these data schemasgives specification regarding the field as wellas its type that will be presented in thedatabase. It formulates overall structure of data whichcan be relational where whole data arearranged in set of tables. Schemas isolate both users and database objectowner. However, with respect to relationalmodel schemas would be set of attributes. The data model is of three type such as logicaldata model, conceptual data model andphysical data model etc. Physical and logical database schemas arebeing regarded as two basic types of dataschemas. In order to formulate the suitable designdatabase, designer has to cover all the dataaspects. Here, designer faces complexity in theprocess when the design of data moves fromconceptual data model to physical one (Collins,Buhalis and Peters, 2003). Data schemas give thorough descriptionregarding entities and the relationship that existbetween them. By using this, database designerprovides help to programmers and thereby itraises understanding of them regarding all theaspects. 1
Data Analysis and Design Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design and Implementation: ER-Model, Relational Schema, Constraints, and Business Intelligence
|5
|1023
|448

Components of DBMS - Doc
|6
|730
|205

Data Analysis and Design Table of Contents
|24
|6051
|216

Logical Database Design Database Design
|21
|2174
|22

Database Model Design
|10
|2343
|341

Database Design and Implementation for Desklib
|23
|5446
|415