Gold Town Gold Town Workers Complaining Poor Organization Car Parking System Result Manage Q43908401
The Gold Town The Gold Town workers have been complaining about the poor organization of the car parking system. As a result, the manager decided that all information related to the car parking should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the car parking. The relevant information is as follows: The Gold Town is an apartment complex from 200 apartments. Each apartment may have one or more than one owner and each owner can have one or more than one apartment. Gold Town owns a parking lot which has a number of parking spaces. The car parking spaces classified into two groups, white and yellow spaces. The white spaces are free for all the apartment owners and their guests. The yellow spaces are rented by one of the apartment owners, who has exclusive use of the space. The rent for the space is added to the apartment rent. The yellow spaces are popular, but the number of these spaces are limited. As a result, the manager of the complex created a queue system.to add the apartments that wish to rent such a space. Each apartment may have only one yellow space. The apartment with the longest queue time has the priority to rent the available yellow parking space. One of the apartment owners must sign the contract. All the problems related with the parking lot, should be registered, such as scrap cars and suspicious cars. Each problem record includes; parking space number, car registration number, decision and date You can make your own assumptions based on the requirements given. However, the assumptions should be clearly indicated / defined. Answer following questions. Provide the following: Identify business rules. Business rules are important to define relevant constraint in the organisations. Some organisations have specific rules only practice by the organisation. (e.g. A business rule for a car sales company may be “for each car separate invoice should be issued.”). You can make any appropriate assumptions and mention them in your answer. (5 marks) Q2 ER diagram is based on the business rules, and should clearly label all entities, entity attributes, primary and foreign keys, relationship, cardinality and connectivity. The primary and foreign keys are optional. Instruction: Use professional software (e.g., MS Office Visio) to draw the ER diagram. Crow’s Foot notation is preferable. (40 marks) Q3 Develop relational schemas. Relational schemas should be derived using the ERD. You should map cardinalities correctly from ERD to Relational Schema. You should clearly indicate the referential integrity constraints (primary and foreign key relationships) using arrows. Clearly indicate datatype for each attribute. e.g Empeid:integer, ename: string(50), address: string(100), did: number) Dept(did: number, dname : string (15)) (15 marks Show transcribed image text The Gold Town The Gold Town workers have been complaining about the poor organization of the car parking system. As a result, the manager decided that all information related to the car parking should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the car parking. The relevant information is as follows: The Gold Town is an apartment complex from 200 apartments. Each apartment may have one or more than one owner and each owner can have one or more than one apartment. Gold Town owns a parking lot which has a number of parking spaces. The car parking spaces classified into two groups, white and yellow spaces. The white spaces are free for all the apartment owners and their guests. The yellow spaces are rented by one of the apartment owners, who has exclusive use of the space. The rent for the space is added to the apartment rent. The yellow spaces are popular, but the number of these spaces are limited. As a result, the manager of the complex created a queue system.to add the apartments that wish to rent such a space. Each apartment may have only one yellow space. The apartment with the longest queue time has the priority to rent the available yellow parking space. One of the apartment owners must sign the contract. All the problems related with the parking lot, should be registered, such as scrap cars and suspicious cars. Each problem record includes; parking space number, car registration number, decision and date You can make your own assumptions based on the requirements given. However, the assumptions should be clearly indicated / defined. Answer following questions. Provide the following:
Identify business rules. Business rules are important to define relevant constraint in the organisations. Some organisations have specific rules only practice by the organisation. (e.g. A business rule for a car sales company may be “for each car separate invoice should be issued.”). You can make any appropriate assumptions and mention them in your answer. (5 marks) Q2 ER diagram is based on the business rules, and should clearly label all entities, entity attributes, primary and foreign keys, relationship, cardinality and connectivity. The primary and foreign keys are optional. Instruction: Use professional software (e.g., MS Office Visio) to draw the ER diagram. Crow’s Foot notation is preferable. (40 marks) Q3 Develop relational schemas. Relational schemas should be derived using the ERD. You should map cardinalities correctly from ERD to Relational Schema. You should clearly indicate the referential integrity constraints (primary and foreign key relationships) using arrows. Clearly indicate datatype for each attribute. e.g Empeid:integer, ename: string(50), address: string(100), did: number) Dept(did: number, dname : string (15)) (15 marks
Expert Answer
Answer to The Gold Town The Gold Town workers have been complaining about the poor organization of the car parking system. As a re…
OR