Ask a question from expert

Ask now

Data Modeling & SQL Language: Assignment

22 Pages2594 Words138 Views
   

Added on  2021-02-20

Data Modeling & SQL Language: Assignment

   Added on 2021-02-20

BookmarkShareRelated Documents
Data Modeling & SQL Language: Part 11
Data Modeling & SQL Language: Assignment_1
ContentsINTRODUCTION...........................................................................................................................3TASK 1............................................................................................................................................3Understanding the database concepts..............................................................................................3Differentiate between the database system and file bases system...............................................3Table: 2........................................................................................................................................4Discuss about the characteristics of hierarchical, network and relational database models andalso represent the practical application........................................................................................5Describe top down and bottom up approaches to the relational database design and alsoidentify the strength or weakness of each approaches.................................................................6TASK 2............................................................................................................................................6Conceptual Modelling.....................................................................................................................6Identify all necessary entities that help to find the problem in DBMS.......................................6Construct the conceptual model of New Airline database and representing with the help ofCrow’s Foot notation. It shows all participation constraints and cardinality..............................7TASK 3............................................................................................................................................7Logical Modelling...........................................................................................................................7Principles of Normalization process by using specific example and also demonstrate theprocess with proper explanations from UNF, 2NF, 1NF and 3NF..............................................7Construct the ERD with normalized entities that contain useful attributes...............................10Mapping the ER model with the set of logical relation into the other relational data model....12TASK 4..........................................................................................................................................14Physical Modelling........................................................................................................................14Produce a script by using appropriate SQL command to create database table by using MySQLand also represent the constraints in the different table level....................................................14Populate the database table........................................................................................................18CONCLUSION..............................................................................................................................21REFERENCES..............................................................................................................................222
Data Modeling & SQL Language: Assignment_2
INTRODUCTIONA database management system is a type of software that support for managing and creating.It provides the systematic approach to design table and also performed different operations suchas retrieve, manage, update and create. This report will discuss about the conceptual frame ofdatabase system to differentiate between the file based and database system. It will describe thecharacteristics of hierarchical, relational and network model. Furthermore, this assignment willdiscuss about the approaches that applicable during database design. Afterwards, it will discussabout the normalization process that demonstrate in the different forms of database system. TASK 1Understanding the database conceptsDifferentiate between the database system and file bases system. File Management systemDatabase Management systemIt is easier to store the file in the systemand requires less constraints or security.It has required the high securityconstraints (Batra, 2018). Data Redundancy is higher in the Filesystem. It is less in the Database managementsystem. It is very hard to get the centralisationin the file management system (Kolevand et.al., 2016). It can be achieved in the centralisationof database system. The security is low in the Filemanagement system. The security is very high in Databasemanagement system. File can be stored in the unstructuredways where data is isolated. DBMS stores the data in structuredform that will define the interrelationand constraints. Table:13
Data Modeling & SQL Language: Assignment_3
Describe about the advantage or disadvantages.AdvantageDisadvantageFile Management System Multiple user accessthe data. Cost and time saving. Maintaining andcontrolling the over thefiles (Jukic, Vrbskyand Nestorov, 2016). Lack of Storage andstandardsLack of transactions. Increases the dataRedundancyDatabase Management SystemDatabase system caneasily access the dataor information. It also preserved thereliability of data andensure the ACIDproperties. It is expensive becausedatabase requires the largespace for disk storage. It has needed the extra cost formaintain hardware system. Table: 24
Data Modeling & SQL Language: Assignment_4
Discuss about the characteristics of hierarchical, network and relational database models and alsorepresent the practical application. Hierarchical Model:Hierarchical model is a tree like structure that can organize the data and information inproper manner. Characteristics of Hierarchical modelIt can be represented the data in the form of hierarchical tree. It has minimized the disk input as well as output in each device (Preidel, Daum andBorrmann, 2017). This model will help for increasing the navigation process and easily access data on time.Network Model Network Model can be designed as flexible approach to represent the specific objects andtheir relationship between them. It is a unique schema that can viewed as graph.Characteristic of Network ModelEach entity is connected as a form of network with each other. It supports the many to many relationships between them. It is maintaining the high performance and speed. Relational Model This model is based on approach for managing and controlling data by usingprogramming language (Borodin, Kiselev and Porshnev, 2016). It can design for the fast storageand retrieval of the large amount of data or information. Characteristic of Relational modelIt is avoiding the data redundancy in the system. It should be maintained the data integrity. This model is standard and portable for ensure that data must be transferred betweenRDBMS. 5
Data Modeling & SQL Language: Assignment_5
Describe top down and bottom up approaches to the relational database design and also identifythe strength or weakness of each approaches. Top down and bottom up approach are two different strategies of information process thatcan include scientific theories and management system. A Top-down approach is generally useful for breaking down the system to gain into thedifferent compositional sub system (Christian, 2017). It is formulating and specifying but nodealing with the level subsystem. It easily specified the black boxes which easier to datamanipulation and also break down into the small segments. A bottom-up approach is dividing the piece of system that can increase the complexityand making the original sub systems. This approach is analysing the individual risk in theprocess at lower level. It always forward looking to control and maintain the process in propermanner.As per scenario, it can use the Bottom up approach for developing the new system at lowlevel. Developer can understand the overall functionality of system TASK 2Conceptual ModellingIdentify all necessary entities that help to find the problem in DBMS. PlaneFlightPassengerEmployeeThese are different types of entities exists in the database system and also creating a relationshipbetween each other. 6
Data Modeling & SQL Language: Assignment_6

End of preview

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

Related Documents
Data Modelling & SQL Language: Assignment
|11
|1420
|93

Data Modelling and Sql Language - Assignment
|18
|2256
|44

Data Modelling & SQL Language
|23
|3728
|185

Database Design and Implementation
|15
|3038
|164

Database Design and Implementation
|15
|3038
|167

Data Modelling SQL Language Tasks 2022
|11
|1864
|21