Hi there,
I'm here to seek for help about my work that is shown in the following scenario. I hope there are people can give me some suggestions. I'm confusing about identifying the correct Entities and the correct Attributes . Please help me.
SCENARIO:
Esquire Hire Company hires out formal wear (suits etc.). The company wishes to computerise it’s operations. You have
been employed as a consultant to design a database for them that will store data related to hirings.
You will need to note the following points about the business:
• The company keeps a large range of items such as suits, shirts, ties etc. Each item is of a particular size,
colour, brand etc. Other details presently kept about items include purchase date and price and hiring rate.
• When customers walk in the door, personal details are taken. These include personal and identification
details, as well as measurements.
• Customers can hire one or more items (eg. suit + shirt + bow tie). They will specify when they want to
pick up the particular items and for how long. They are told how much the items will cost per day. A
record is also made of the alterations the items will require before they are picked up.
• When the items are returned, they are checked for damage. If any damage has occurred, it is noted, as well
as the cost of repairing the damage. This is charged to the customer.
The company periodically buys new stock from it’s suppliers. Old stock is sold to a second hand clothing dealer
Provide the following for the new database:
• Entity Relationship Diagram.
• Third Normal Form Relational Model
(showing fields, primary keys, foreign keys and concatenated keys).
Entities I got now:
-Customer
-Item
-Hire
-Measurement
-Damage_Check
Thank you for your attention!
Regards