Draw the er diagram for the database

Assignment Help Computer Engineering

Reference no: EM133422690

Question: Suppose that you need to design a simple database for COVID-19 testing. Some basic requirements are as follows.

- There are many test centers in Hong Kong. Each test center has an id, a name, and an address. A test center can serve many clients.

- A client can go to any test center for testing. A client has an id, a name, and a phone number.

- The client should make an appointment before he/she sets out for testing. Each appointment should have the id of the client, the id of the test center, and the appointed time.

The test center takes a swab sample for a client and the testing result of the sample will be sent to the client within 48 hours.

(a) Draw the ER diagram for the database. You need to specify the keys of the entity sets and relationship sets. You also need to mark the cardinality and participation constraints of the relationship sets and explain the reason for the constraints. Note that this question is open and different designs are possible due to different considerations.

(b) Map the ER diagram in (a) to the relational tables (Write down the SQL for creating these tables). You need to capture as many constraints in the ER diagram as possible. If you cannot capture a constraint, you need to explain the reason.

Reference no: EM133422690

Questions Cloud

Why are the interests of society of utmost importance : Why are the interests of society of utmost importance? Why must you always think about what is best for society and act accordingly

How do you think that protein folding is involved in these : how do you think that protein folding is involved in these disorders and how does the disease progress in individuals with these disorders?

Explain the prisoners dilemma : Explain the prisoner's dilemma and discuss how social contract theory morality can be seen as a solution to this dilemma.

What is the evolutionary origin of the chloroplast : According to the endosymbiotic theory of eukaryotic evolution, what is the evolutionary origin of the chloroplast and the mitochondria in eukaryotic cells?

Draw the er diagram for the database : Draw the ER diagram for the database. You need to specify the keys of the entity sets and relationship sets. You also need to mark the cardinality

How do we target chaperones and co-chaperones : How do we target chaperones and co-chaperones in neurodegenerative diseases to effectively control protein misfolding and prevent aggregation?

Design a privacy policy that you would like to see added : Design a privacy policy that you would like to see added to the site. How should the policy be worded? Where (location on the site) would you add this

How many page faults would occur : How many page faults would occur using the MIN replacement algorithm, assuming four frames? Remember that all frames are initially empty, so your first unique

Explain what paraprofessionals and other support staff : Explain what paraprofessionals and other support staff members will do to assist with instruction and direct services. Include discussion of how the aspects

User Account

All Pages