logo

The ERD of A&H Boating Assignment

   

Added on  2021-04-19

6 Pages961 Words52 Views
1. The ERD of A&H BoatingFigure 1: ERD of A&H Boating2. ERD with Model DescriptionFigure 2: ERD after task 2 Completion
The ERD of A&H Boating Assignment_1
3. ERD with Warehouse Details Figure 3: ERD of A&H Boating after task 3 4. Final ERD Model of A&H BoatingFigure 4: ERD of A&H Boating
The ERD of A&H Boating Assignment_2
Logical DesignEntitiesAttributesA&HBoatingBranchCode, BranchName, BStreet, BCity, BState,BPinCode, MCode, ModelNameForeign key (MCode) references ManufacturerDetails(MCode)Foreign key (ModelName) referencesModelDescription (ModelName)ManufacturerDetailsMCode, MName, MStreet, MCity, MState, MPostCode,MPhoneNumber, MAccountNumberBoatTypeModelCode, MCode, ModelName, BoatPurpose,DescriptionForeign key (ModelCode) references ModelDescription(ModelNumber)Foreign key (MCode) references ManufacturerDetails(MCode)ModelDescriptionModelNumber, ModelName, DateOfManufacturing,Engine, Length, BeamSize, Weight, PriceWarehouseDetailsWarehouseID, ModelNumber, MName, MStreet, MCity,MState, MPostCode, MPhoneNumberForeign key (ModelNumber) referencesModelDescription (ModelNumber)CustomerDetailsCEmailID, WarehouseID, CFName, CLName, DOB,CStreet, CCity, CState, CPostCode, CPhoneNumberForeign key (WarehouseID) referencesWarehouseDetails (WarehouseID)Table 1: Logical Diagram of A&H BoatingBusiness RulesEntitiesRelationshipsA&HBoating - ManufacturerDetailsOne to many relationshipManufacturerDetails - BoatTypeOne to many relationshipA&HBoating - ModelDescriptionOne to many relationshipBoatType - ModelDescriptionOne to one relationshipBoatType - WarehouseDetailsOne to one relationshipCustomerDetails - WarehouseDetailsOne to many relationshipModelDescription - WarehouseDetailsOne to one relationshipTable 2: Business Rules taken in ERD of A&H Boating
The ERD of A&H Boating Assignment_3

End of preview

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

Related Documents
(PDF) Database systems for hull form design
|9
|996
|230

Gaming Shop Databas Assignment
|9
|755
|283

Database Management System Assignment 2022
|32
|6949
|24

Advanced Management Console
|35
|7601
|31

Database Management System of Beta University Assignment
|6
|869
|167

Database Implementation Assignment 2022
|24
|2500
|10