(а) Refer to Figure Q3(a)(i) for the data model for equipment loans. Customer Equipment Loan id equipmentCode name id name equipmentCode address description RentalRatePerDay contact startDate dateOfBirth returnDate occupation DamageReport reportId damageType Figure Q3(a)(i) (i) Derive the logical model from the data model in Figure Q3(a)(i).

Part 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4 Your model should have at least 5 tables You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table) Your model should be normalized Identify the primary key in each table, and state whether it is a natural or surrogate key For each relationship between tables, identify any foreign keys needed to define the relationship For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.

Draw the schema mapping (logical database design) for the following part of ER diagram for train station database. When appropriate use the foreign key option. E.ID E.name EMPLOYEE M works-on 1 S.ID S.name STATION S.location

how to map ERR model to relational model

convert ER diagram to relation model

In order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity?  There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute.

(iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. DateOflirth Ocupation Number of Equipment Rented Total Rant NumDamage 20.00 Name Address Contact S7615882J Charles Toles 23 Haig Road 92142331 15-03-1978 Teacher 1 S8512123F Damien Low 5 Sil Roed 88128833 05-07-1985 Teacher 16.00 3 S8823456F Audrey Ng 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 4 S9012345G Betsey Tan 2 Jalan Eunos 98981212 12-05-1990 Cartoonist 2 4.00 S9144234J Peter Lee 8 Jalan Melayu 97589758 04-03-1991 Student 24.00 S97123452 Ai Bin Mohd Hassan 10 Clementi Road 91239123 10-07-1997 IT Programmer 0 0.00 S9945875J Ravi SIO Ramasamy 12 Jurong Road 82223333 12-08-1998 Personal Trainer 0 0.00 (iv) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not…

translate the following ER diagram into the appropriate relational schema(s):

Describe how functional dependencies may be used to show: • There is a many-to-one connection set between the entity sets student and instructor, as well as a one-to-one relationship set between the two.

Explain how functional dependencies can be used to indicate the following: A one-to-one relationship set exists between entity sets student and Instructor. A many-to-one relationship set exists between entity sets student and instructor.