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 onelor 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: ppropnate asumptions and (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. Emp( eid: integer, ename: string(50), address: string(100), did: number) Dept(did: number, dname : string (15)) (15 marks) 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 onelor 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: ppropnate asumptions and (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. Emp( eid: integer, ename: string(50), address: string(100), did: number) Dept(did: number, dname : string (15)) (15 marks)
