Table of content INTRODUCTION...........................................................................................................................1 TASK 1............................................................................................................................................1 Database management system.........................................................................................................1 Differentiate between the file and database management system...............................................1 Properties Network, Relational and Hierarchical data models....................................................2 Bottom up and Top-down approach of relational DBMS design................................................3 TASK 2: CONCEPTUAL MODELLING.......................................................................................4 Possible entities...........................................................................................................................4 Conceptual data model for the New Airline database.................................................................4 TASK 3............................................................................................................................................5 LOGICAL MODELLING...............................................................................................................5 Normalization Method.................................................................................................................5 Entity relationship diagram..........................................................................................................7 TASK 4: PHYSICAL MODELLING...........................................................................................13 SQL Commands and database tables.........................................................................................13 CONCLUSION..............................................................................................................................16 REFERENCES..............................................................................................................................17
INTRODUCTION A DBMS is aprocess that can gather and collect the information to store, retrieve and update in the database system. It is used MySQL tool and platform to interface with the informationaboutdatabaseforstorageandretrieval.Thisreportwilldiscussaboutthe differentiation between the file base system and database. Furthermore, it will identify the characteristics of data models. This documentation will discuss about the top down and bottom up approach in relational database to examine the entire processing of DBMS. It is understanding the entity relational modelfor establishing the relation between different entities. It also contains the conceptual modelling to identify the entities and create the conceptual model. Moreover, this report will identify the structure query statement that can use for designing table and columns in the system. TASK 1 Database management system Differentiate between the file and database management system. Database can be defined as a set of structure of data which is used to collect information in a specified manner so that it can easily be accessed, updated, modified and retrieved. It makes evaluation of information easy(Egea and Dania, 2019). There are various kinds of database managed systems that are used to store information and manage different databases. Database systems makes is much easier for the end user to update, create, read, delete data in a specified manner such that other information stored within the database is not hampered. As per the case study JetAirlines wants to create dynamic relational DBMS inorder to maintain therequirement of theirgrowing business. Fine management system can be defined as an application which is used to store, arrange aswellasaccessinformationor filesfromstorage locations.Eachfilewithinthisfile management system manages as well as defines their own data or information (Ghali and AbuNaser, 2019). There are various kinds of limitations because I this each and every user need to maintain and create their own files which are run through a specific program. Due to which it becomes difficult for the user to maintain, update, create or evaluate the information. 1
Properties Network, Relational and Hierarchical data models Relational: It is the most common model that helpfor sorting data into different tables and establish relationship with one or more tables.It is mainly containing different rows or columns. Every column has a contain the unique attributes(Odarchenko, Hassan and Zaman, 2019). This model is mainly accounts for different types of relationship between tables such as one to one, one to many and many to many etc. Characteristics: Relational model is represented in the form of tables that contain specific values within rows. It also supports the inapplicable and missing information in proper manner. It must be supports the logical and physical data dependence. Relational data model is also supports the independence of distribution the overall management system. Hierarchical Hierarchical Model can organizeinformation in the form of tree structure so that each record has a contain the single parents. It is sorting in particular order and also used as physical order for sortingthe DBMS. Characteristics: It is based on the structured data model andstructured in the tree. It provides the navigation path to access the information through tree like structure. It is mainly used for the logical pointers. Network It is mainly builds on the hierarchical model that can build many to many relationships. It is also used the mathematical concept to create an effective network system and also constructed with set of related records. Characteristics: It can be supports the many to many relationships. All the entities are shown in the form of connected network with each other. It always maintains high performance. Network model is powerful than the other models. 2
End of preview
Want to access all the pages? Upload your documents or become a member.