The Conceptual and Logical Database Design
Added on -2020-02-19
| 9 pages| 676 words| 110 views
Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 3 of 9 pages
Running head: THE CONCEPTUAL AND LOGICAL DATABASE DESIGNThe Conceptual and Logical Database DesignName of the StudentName of the University
THE CONCEPTUAL AND LOGICAL DATABASE DESIGN1Table of Contents1. Conceptual Database Design:..........................................................................................21.1 Data Dictionary:.........................................................................................................21.2 ER-Diagram:..............................................................................................................62. Logical Database Design:................................................................................................72.1 Entity Relationship Diagram:....................................................................................72.2 Database Visualization through Table:......................................................................7Bibliography:.....................................................................................................................10
THE CONCEPTUAL AND LOGICAL DATABASE DESIGN21. Conceptual Database Design:1.1 Data Dictionary:EntityAttribute NameDescriptionData Typeand LengthNullsMulti-valuedCustomerCustIDThe uniquevalue foridentifyingrow 4 FixedcharacterNoNoNameThe nameof thecustomer20 VariableCharacterNoNoAddressTheaddress ofthecustomer30 VariableCharacterNoNoContactThe contactnumber ofthecustomer10 VariableCharacterNoNoEntityAttribute NameDescriptionData Typeand LengthNullsMulti-valuedTicketTicketNoThe uniquevalue foridentifyingrow 4 FixedcharacterNoNoIssueDateThe date ofcar parkingentry20 VariableCharacterNoNoIssueTimeThe time ofcar parkingentry30 VariableCharacterNoNoIssueMachineMachinefrom whichthe ticketwas issued10 VariableCharacterNoNoEntityAttribute NameDescriptionData Typeand LengthNullsMulti-valued
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss