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

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this