Ask a question from expert

Ask now

ERD. Relational Data Model. Owner(OwnerID, OwnerName, O

5 Pages428 Words315 Views
   

Added on  2019-10-18

ERD. Relational Data Model. Owner(OwnerID, OwnerName, O

   Added on 2019-10-18

BookmarkShareRelated Documents
ERDRelational Data ModelOwner(OwnerID, OwnerName, OwnerContactNo, OwnerAddress, OwnerEmail)SailBoat(BoatID, BoatSize, LeasingRate, OwnerID)Equipment(EquipmentID,EquipementType,EquipementName,ProvidedBy)CharterEquipment(CharterEquipmentID,EquipmentID,CharterID)Charter( CharterID, DepDate, RetDate,CustomerID,BoatID,TotalCost)Customer(CustomerID,CustomerName,CustomerContactNo,CustomerAddress,CustomerEmail)SkipperOrCrew(SkiOrCrewID, Type,Fee, CharterID)CharterRecord(CharterRecordID,Date,Time ,CharterID)
ERD. Relational Data Model. Owner(OwnerID, OwnerName, O_1
Data DictionaryOwnerColumn NameData TypeConstraintsDescriptionOwnerIDTextPrimary KeyEvery ownerhas unique identification numberOwnerNameTextNot NullOwner nameOwnerContactNoNumberNot NullOwner contact numberOwnerAddressTextNot NullOwner addressOwnerEmailTextNot NullOwner EmailSailBoatColumn NameData TypeConstraintsDescriptionBoatIDTextPrimary KeyEvery Sailboathas unique identification numberBoatSizeTextNot NullBoat sizeLeasingRateCurrencyNot NullBoat leasing rateOwnerIDTextForeign keyReference Table name OwnerEquipmentColumn NameData TypeConstraintsDescriptionEquipmentIDTextPrimary KeyEvery Equipmenthas unique identification numberEquipementTypeTextNot NullEquipment typeEquipementNameTextNot NullEquipment nameProvidedByTextNot NullEquipment provided byCharterEquipmentColumn NameData TypeConstraintsDescriptionCharterEquipmentIDTextPrimary KeyEvery Charter Equipmenthas unique identification numberEquipmentIDTextForeign keyReference Table name Equipment
ERD. Relational Data Model. Owner(OwnerID, OwnerName, O_2

End of preview

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

Related Documents
ArtisT-MUSIC Management System
|15
|861
|125

Term Project ERD
|7
|684
|295

Model Description of the Trading Company
|3
|736
|354

Restaurant Management System Analysis
|15
|1266
|20

Database Design in Oracle for Pet Net Online Library
|30
|4417
|90

A Model Description: Jo Bloggs Auto Traders
|4
|815
|451