help please

Anonymous

Question 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

Tutor Answer

Professor_Markins
School: New York University

Please go through the an...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors