Data Analysis and Design Sample Assignment

Added on - 11 Jan 2021

  • 25

    pages

  • 4475

    Words

  • 8

    Views

  • 0

    Downloads

Showing pages 1 to 6 of 25 pages
Data Analysis Design
Table of ContentsINTRODUCTION...........................................................................................................................3TASKS............................................................................................................................................3LO1..................................................................................................................................................31.1 Various types of data model and Schema in the data analysis..............................................31.2 Different types of database management system and also includes limitations and benefits.....................................................................................................................................................71.4 Analyse the various types of approaches in the development process................................9LO2................................................................................................................................................112.1 Design relational database system......................................................................................112.2 Build a relationship database system in My SQL Server....................................................112.3 Discuss the different types of database tool and technique to enhance the user interface..11LO3................................................................................................................................................113.1 Discuss the SQL and its features and functionalities and benefits of query tool in therelational database system.........................................................................................................113.2 Apply the SQL to implement in the query language in the relational database system......123.3 Features of Query language tool and data extracting through the query tool.....................13LO4................................................................................................................................................144.1 Different types of testing methods:.....................................................................................144.2 Create test plan in the form of table of “BIKE SOLUTION” Database.............................144.3 Importance of technical and user documentation................................................................144.4 verification and validation in the relational database system..............................................144.5 Discuss the control mechanism and used for the relational database system....................14CONCLUSION..............................................................................................................................15REFERENCES..............................................................................................................................16
INTRODUCTIONDatabase management system is a process or method for collecting the entire data andinformation in proper format. Data management is an essential part of each and everyorganization that provide the facility to read, create, update and delete the data in the databasesystem. It is the most common and effective process to provide the centralized view of datawhere meany user can view or access the data in proper manner. This report will discuss aboutthe bike solution company that manage their business operations and function by using DBMS.This report will describe the various types of data model and data schema to collect theinformation in proper manner. There are different approaches uses in the database developmentand also helpful different tools and techniques to collect the information in effective ways.Furthermore, At last task, it also designs an effective database system by using SQL server.TASKSLO11.1 Various types of data model and Schema in the data analysisData model is basically a model that shows the logical representation of database . It alsoincludes the constraints and having specific relationship between them. Data model is used thespecific rules for designing the effective structure.There are different types of data model used in the database management system.Relational data model-this is the most common data model where it can sort the data inform of tables and also creates relationship between them. This tables contain the rowsand columns and each or every column has specific attributes. This model follows thedifferent relationship such as one to many, one to one, many to one and many to many etc(Agresti, 2018).
Hierarchical data model-Hierarchical model is based on tree like structure thatorganize data and information in proper ways. Each record has single parents thatrepresented in the form of tree (de Zoeteand et.al., 2017). There are one single parentswhich is known as roots. It is basically used for physical order to sort the data. Thismodel is describing the real type's relationship.
Network data model-This model allows the hierarchical model to create many to manyrelationships between the each records of data, According to mathematical concept, thismodel is constructed by using specific set of records. A record can be member ofdifferent sets that allow conveying the complex structure and relationship.
Data schema-Data base schema is the main part of database management system that representthe logical view of entire database system. It is also organized the data and creates relationshipbetween the tables or columns. In this way, all the important constraints and formulas can beapplied on it (Ghilani, 2017). It is contained the explanation of database in details that help forprogrammer to understand the concept behind the database design.Database can be divided into two parts:Physical database schema-This schema is the actual storage of data that contain all theinformation and data in form of indices and files. Data can sorted by using the secondary storage.Logical database schema-Logical schema is defined the all the important logical constraintsthat required for managing the database and also applicable in the storage data
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