Parramatta City Council Car Park System
Added on 2020-02-19
9 Pages676 Words110 Views
|
|
|
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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents