Database management system | Computer Science homework help

I am (Faiz Lakhani) and I complete this assignment following the UHD academic integrity policy.

1. Use
Microsoft Visio or to draw the diagram. Diagrams made by any other tools will
not be graded.

2. Use
IE (crow’s foot) notation. Diagrams with any other notations will
not be graded.

3. The diagram should specify entities, keys, attributes, relationship types (identifying or non-identifying), and cardinalities (MAX and min on each side). Divide an attribute further into simple attributes when appropriate. All many-to-many relationships, if any, should be converted into associative entities (the answer should not have many to many relationship). Relationship labels are not needed.
Use a specialization hierarchy when appropriate. Grading is based on the completeness of the diagram.

4. Add a textbox with your full name inside the diagram (no point without your name). The figure below is an example.

5. Paste your diagram in this document and
submit this document. Any submission other than this document will
not be graded.

1. (8 points) The following are two tables with data for a Customer-Order database. Answer the following questions based on these two tables.

Table  Description automatically generated

a. Explain entity integrity. Do the tables exhibit entity integrity?


b. Explain referential integrity. Do the tables exhibit referential integrity?


(7 points) Dormitory Administration System

You are designing a dormitory administration system. The university has several dorms, each has many rooms. A dorm is identified by its dorm ID. Besides, a dorm has a dorm name, street address, city, state, and zipcode. Each room is identified by a combination of dorm ID and room number. Besides, a room has number of beds, and monthly rent.


[Paste the diagram here.]

(20 points) Clinic Appointment System (Must Use Supertype-Subtype Entities)

You are asked to design a database system for a clinic appointment system. The requirements for the appointment system are summarized as the follows.

· There are three types of persons in the system: staff, physicians, and patients. Any data about a person in the system must be stored in
one of these three categories (and cannot be simply stored as “person”). In addition, a person cannot be two categories at the same time (e.g., a person cannot be a staff and a patient simultaneously).

· The system has data about the staff’ ID, first name, last name, phone, and address.

· The system should contain data about physicians, including their ID, first name, last name, phone, address, certificate, and specialty.

· The system has to track information about patients. A patient, identified by its ID, has information including first name, last name, phone, and address.

· A patient can make appointments with a physician through the system. A patient may make several appointments in the system. A physician may have several appointments in the system. For each appointment, only one (and at least one) patient is involved. In some occasions, there may exist an appointment without a physician on it. Data about an appointment includes appointment ID, time, date, reason, and the patient and the physician for the appointment.

· One appointment may have one or more diagnoses. Each diagnosis has its own diagnosis ID, description, and treatment.


[Paste the diagram here.]

4. (15 points) Book publisher system. Draw an ER diagram for the following case.
The E-R diagram should include entities, attributes, identifiers, and relationships. In the diagram, place a textbox at the top-left corner of your diagram and type
Made by FirstName LastName in the textbox (5 points).

· A book is identified by its ISBN number, and it has a title, a price, and a date of publication. A book is published by a publisher, which has its own publisher ID number and a name. Each book has only one publisher, but one publisher typically publishes multiple books over time.

· A book is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books. A book may have several authors.

· Additional information is needed regarding the relationship between a book and its authors. An author may have different royalty rates for different books that he/she wrote. Also keep in mind that a book may have several authors (hence several royalty rates).


[Paste the diagram here.]




Made by Shuaifu Lin


Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Need help?