ZuoTi.Pro
Question

(NOTE: ERD’S must use the Crow’s Foot notation documenting entities, “assumed” attributes, keys, and relationships) The...

(NOTE: ERD’S must use the Crow’s Foot notation documenting entities, “assumed” attributes, keys, and relationships)

The campus infirmary needs to create a database system to keep track of patients, doctors, and drug prescriptions.

  • A doctor can write one or more prescriptions, but each prescription can only be written by one doctor.
  • A patient may receive one or more prescriptions, but each prescription is for only one patient.
  • A drug may appear in one or more prescription(s) and a prescription may have one or more drugs.
science   nursing   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Entity-relationship diagram deals with database and represents the data in the structured form in the system and shows their relationship. The workflow consists of the entity, attributes, and relationship. Entity is the collection and storage of information in the system to remember. attributes are the element or characteristic that describe the entity and the relationship is the connection between the entities.

Sample database system to keep track of patients, doctors, and drug prescribers.

PATIENT BE TREATED BY PHYSICIAN PRESCRIBEID By TAKEN 3y HAVE BEEN PRESCRIBED PRESCRIPTION HAVE BEEN APPEAR DRUG

This ERD model represents the relation between the physician, prescription, drug, and patient. always the entities should be in singular form. This will be implemented as a database in the system to get work done as by it.

0 0
Add a comment
Know the answer?
Add Answer to:
(NOTE: ERD’S must use the Crow’s Foot notation documenting entities, “assumed” attributes, keys, and relationships) The...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Q3: You have been hired to design a database for prescriptions for RX pharmacies and your...

    Q3: You have been hired to design a database for prescriptions for RX pharmacies and your first job now is to design an ER model for this database using the following description of that world. i. patients are identified by their SSN and have other attributes as names, addresses, and ages. ii. Doctors are identified by their SSN and have other attributes as names, specialty, and years of experience. iii. Each pharmaceutical company is identified by name and has a...

  • Question: Draw the ER diagram of your database design in Crow’s Foot notation. RULES OF DATABASE...

    Question: Draw the ER diagram of your database design in Crow’s Foot notation. RULES OF DATABASE Each thesis has the following mandatory attributes: thesis no (numeric), title, abstract, author, year, type (one of Master, Doctorate, Specialization in Medicine, and Proficiency in Art), university, institute, number of pages, language (Turkish, English, etc.), and submission date, A person can be author of more than one theses (for example, a person can prepare a Master thesis, later s/he can prepare a Doctorate thesis),...

  • E/R diagram: Draw a complete Doctors office system E-R diagram using UML or crow’s foot notation...

    E/R diagram: Draw a complete Doctors office system E-R diagram using UML or crow’s foot notation that includes all of the entities, attributes, identifiers. Relationships should be appropriately labeled with verb phrases. Make it neat. Once the E-R model has created, convert the E-R model to a set of relations by using rules. We will call this set of relations the initial set of relations derived from the E-R model. You use to implement your database application in MS Access....

  • 11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for...

    11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. b. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in...

  • Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...

    Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...

  • Consider the following information about a patient database: A patient is identified by patient id, and...

    Consider the following information about a patient database: A patient is identified by patient id, and admission date. A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD...

    QUESTION 1 1. Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). Each city may have many sport teams. The number of teams is limited to 20 per city. b). Each team belongs to one and only city. c). Each team has at...

  • c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...

    c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...

  • Question 3 refers to the relational database with a schema described below: The hospital database contains...

    Question 3 refers to the relational database with a schema described below: The hospital database contains information about the treatments of patients performed by the doctors. The database also contains information on the prescriptions ordered by the doctors. The schemas of relational tables, the meanings of attributes and specifications of primary, candidate, and foreign keys are given below. HOSPITAL HospitalCd Name Address Estate PostalCode EstablishedDate Hospital Code Name of the hospital Address of the hospital The estate where the hospital...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT