help please

User Generated

snnyb2

Programming

Description

I need help and follow all the information on the paper and please read the chapter 1-2-3 you see it in the link

think you

https://urldefense.proofpoint.com/v2/url?u=http-3A__www.academia.edu_15013157_Modern-5FDatabase-5FManagement-5F11th-5FEdition-5F&d=DwMBaQ&c=0CCt47_3RbNABITTvFzZbA&r=J3Cqi5mOXm5dKMwVKAkQWPS01B47pjtCPj8Kgz5D398&m=LP6-RpVHCIQaLJ-LroUmj69usBwyRQ2OUGS7vI6COq4&s=dFsquF3aqcp_hMOiVBNwWKZoPxzWfOgb1HPJj0XYihE&e=

3 days ago

Unformatted Attachment Preview

PROJECT 1 Create a space between each of the questions and draw (you may hand draw, but it MUST be clear – I will not guess what your drawing is showing) the diagram or diagrams. This project is an individual assignment; it should be done on your own (you may use the text but you should not be discussing the assignment in no way with ANYONE). 1. Express the relationship(s) graphically with an E-R diagram (show degree and cardinality) A book is identified by its ISBN number and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time (pg. 102). 2. Develop an EER diagram for this situation You are working for a large country club. This country club wants to keep a database on its members and their guests. For each member, the club keeps mail and telephone contact information, name, and membership number. When you join this club, you can join as a social member (which allows you 2 rounds of golf a year as well as privileges to the swimming pool and weight room), a tennis member (which allows you all the privileges of a social member as well as use of the tennis courts and 4 rounds of golf), or a golfing member (which allows you all the privileges of a tennis member and unlimited use of the golf course). 3. For a library, the entity type HOLDING has 4 subtypes: BOOK, AUDIO BOOK, DVD, and SOFTWARE. Draw a separate EER diagram segment for each of the following situations (put each diagram under the letter/instructions you are diagraming for): a) At a given time, a holding must be exactly one of these subtypes. b) A holding may or may not be one of these subtypes. However, a holding that is one of these subtypes cannot at the same time be one of the other subtypes. c) A holding may or may not be one of these subtypes. On the other hand, a holding may be any two (or even four) of these subtypes at the same time. d) At a given time, a holding must be at least one of these subtypes. 4. Use the below figure to complete the following steps: a) Transform the EER diagram to a set of relations and develop a relational schema b) Diagram the functional dependencies and determine the normal form for each relation 1 c) Convert all relations to third normal form, if necessary, and draw a revised relational schema d) Suggest an integrity constraint that would ensure that no property is rented twice during the same time interval. 2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please go through the an...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags