Assignment on Database Systems Database Design & Implementation

Added on - Jan 2021

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 19 pages
DATABASE SYSTEMS DATABASEDESIGN & IMPLEMENTATION
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................3TASK 1............................................................................................................................................3Construct data models according to the business rules and showing primary key, foreign key,entity and attributes................................................................................................................3TASK 2............................................................................................................................................5Normalization.........................................................................................................................5TASK 3............................................................................................................................................6Create Data definition language of database table.................................................................6TASK 4..........................................................................................................................................15Screenshot of database table and insert record into the table...............................................151.....................................................................................................................................................15TASK 5..........................................................................................................................................16Solve queries........................................................................................................................16
INTRODUCTIONTASK 1Construct data models according to the business rules and showing primary key, foreign key,entity and attributes.Entity-It is a real world entity of particular object in the form of entities. In databasemanagement system, all data are stored in the form of table containing information such ascustomer, account, bank, debit card, department and loan etc.Attributes- Attributes is an instance of data in database system. Attribute is quality ofcharacteristic of particular person and place.Primary key-This is main concept that specify the relationship between tables andcolumns. It can be designed for representing unique identity in database table.Foreign key-It is a group of data in a table that is relational database and link betweentwo tables.Data Model Diagram
Figure 1: Data Model
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access