Week 2 Entities and Relationships Project

Week 2 Entities and Relationships Project three inquiries that a database could address are as follows:

1. What is the most common reason for patients’ visits?
2. What drug is most frequently prescribed?
3. What laboratory test is most commonly requested? above just for your knowledge and my week 2 homework start as below from instruction)

Instructions

As you further consider the information problems and design of the database from your Week 1 discussion, address the following:

1. Name two-to-five entities (also known as entity classes in your text) that will be part of your database.
2. Explain why you have chosen these entities.
3. Using the Chen format shown and discussed in the Oppel text, draw an entity-relationship (E-R) diagram for two entities, name the identifier for the selected entities, and attach the drawing to your discussion post. Remember, an entity relationship requires at least one other entity. Use a software program or Microsoft Word symbols to depict your diagram aspects.

Week 2 Entities and Relationships Project

Tips for Developing Effective E-R Diagrams

Click on the following tabs for tips:

• Name entity attributes
• Describe relationships
• Color code
• Example

Name each entity and its attributes.

• Are all of the entities listed?
• Are there any duplicate entities? If so, remove the duplicates, since each entity should appear only once in each diagram.