Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Entities: Owner Attributes: OwnerID ( identifier ) , Name, Contact Information, Address Property Attributes: PropertyID ( identifier ) , Address, Size, Description Employee Attributes: EmployeeID

Entities:
Owner
Attributes: OwnerID (identifier), Name, Contact Information, Address
Property
Attributes: PropertyID (identifier), Address, Size, Description
Employee
Attributes: EmployeeID (identifier), Name, Position, Contact Information
Service
Attributes: ServicelD (identifier), Description, Date, PropertylD (foreign key), EmployeelD (foreign key)
Equipment
Attributes: EquipmentID (identifier), Name, Description, Date of Purchase, OwnerID (foreign key)
Subproperty
Attributes: SubpropertyID (identifier), Description, PropertyID (foreign key)
EquipmentUsage
Attributes: UsageID (identifier), ServiceID (foreign key), EquipmentID (foreign key), Date, Notes
EquipmentRepair
Attributes: RepairID (identifier), EquipmentID (foreign key), Date, Description, Cost
Training
Attributes: TrainingID (identifier), EmployeeID (foreign key), EquipmentID (foreign key), Date, Notes
create a conceptual Entity Relationship (E-R) model for Garden Glory to represent the entities and relationships involved
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions