(a)Refer to Figure Q3(a)(i) for the data model for equipment loans.CustomerEquipmentLoanidequipmentCodenameidnameequipmentCode >eaddressdescriptioncontactstartDateRentalRatePerDaydateOfBirthreturnDateoccupationDamageReportreportIddamageTypeFigure Q3(a)(i)(i)Derive the logical model from the data model in Figure Q3(a)(i). (ii)Refer to the description of columns in Table Q3, and implement the tables using theappropriate SQL statements. List the SQL statements in the order that they shouldbe executed.DescriptionA string that is exactly 9 characters. The first is a letter which is either S orT and last character is an alphabet. The characters in between are digits.ColumnsidName (customer)A string that is exactly 50 characters.A string that is at most 100 characters.A string that is exactly 8 digits.A date. A customer must be at least 21 years old in the year registered.A string that is at most 30 characters. This attribute is optional.A string that is exactly 5 characters.addresscontactdateOfBirthoccupationequipmentCodename (equipment) A string that is at most 50 characters.descriptionRentalRatePerDay A decimal number between 4 and 50, inclusive.startDate,A string that is at most 255 characters. This attribute is optional.returnedDatereportlddamageTypeBoth are date but returnedDate is optional. returnedDate must not beearlier than startDate.An auto-generated value starting with 1 and an increment of 1A string that is at most 16 characters, and is either 'Wear and tear' or'Customer Damaged'Foreign key constraintsMinimum cardinality between Customer and Loan is 1:N, M:0 with delete and update cascaded.Minimum cardinality between Loan and Equipment is 1:N, M:0 with delete disallowed andupdate cascaded.Minimum cardinality between Loan and DamageReport is 1:1, M:0 with delete and updatedisallowed.Table Q3

As per our answering guidelines, when there are more than one un-related question , we are supposed…

Answered: (а) Refer to Figure Q3(a)(i) for the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

ER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.
Transform into relational model (relations). IMPORTANT: The diagram needed for the second part uses a different notation for cardinality constraints. You can deduce the notation from the following: Each employee can work for exactly one department, and each department can have at least one employee. Each department has exactly one manager, and each employee manages at most one department. Each employee has at most one supervisor, and each supervisor can have several supervisees.
Use the following diagram relation to perform the normalization. You need to provide the Dependency Diagram and 1NF.
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.

SEE MORE QUESTIONS

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS