logo

Database design and development - Assignment

   

Added on  2021-01-03

20 Pages1679 Words88 Views
 | 
 | 
 | 
Database design and development
Database design and development - Assignment_1

Table of ContentsINTRODUCTION...........................................................................................................................3PART A...........................................................................................................................................3Database tables- .........................................................................................................................5Airline table-...............................................................................................................................5Entity Relationships-...................................................................................................................8Queries-.....................................................................................................................................10Integrity constraints- ................................................................................................................13PART B..........................................................................................................................................14CONCLUSION .............................................................................................................................18REFERENCES..............................................................................................................................19
Database design and development - Assignment_2

INTRODUCTIONDatabase management is a process for creating and managing the database effectivelyand efficiently. It provides the programmer and user to create, retrieve, update, delete andmanage the data in effective manner. In part A, it will discuss about the normalization techniqueto create 3NF relation. It will design the relational database system to identify the relationshipbetween the database tables and also generate the query by using Ms Access. In part B, it willdesign ER model of car rental activity and also create relationship between the three differententities. PART ANormalization- It is a database design technique that organize the tables in appropriate manner. Italso reduces the dependency and redundancy of data (Wynn, 2018).a)1 NF- 3 NF -
Database design and development - Assignment_3

Third normal form is basically used in the normalization of database that design to reduce theduplication in the data(Djenouhat, Belala and Barkaoui, 2018). 3NF design is improved theprocessing of database that minimize the storage of cost. Customer table contain primary keythat shows as foreign key into the booking detail table. On the other hand, it will createrelationship between the two tables. Afterwards, it is reduced to minimize into the single tablelike booking table.Customer tableprimary key – customer idbooking detailforeign key- customer idprimary key- reservation id In this way, it can be designed the one to many relationships whereas foreign key isdeepened on the primary key. All the other non key attributes are depended on the primary key. b) List Functional dependencies-booking date
Database design and development - Assignment_4

End of preview

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

Related Documents
Database Design and Development
|7
|1063
|493

Database Management System Design
|39
|3339
|277

Introduction of DBMS (Database Management System)
|28
|2805
|27

Introduction to ERD Diagram
|6
|1099
|602

Entity Relationship Diagram for Database INTRODUCTION 3 TASKS
|20
|1532
|227

Database Design and Development for Flight Booking System
|14
|1653
|386