logo

The Conceptual and Logical Database Design

9 Pages676 Words110 Views
   

Added on  2020-02-19

The Conceptual and Logical Database Design

   Added on 2020-02-19

ShareRelated Documents
Running head: THE CONCEPTUAL AND LOGICAL DATABASE DESIGNThe Conceptual and Logical Database DesignName of the StudentName of the University
The Conceptual and Logical Database Design_1
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 Design_2
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
The Conceptual and Logical Database Design_3

End of preview

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

Related Documents
Collection of Logically Related Data - Desklib
|6
|563
|99

Database Design and Use Report 2022
|31
|2129
|20