Must have visio! In this iLab, you will create an entity relationship diagram (ERD) for a portion of a database.

Would you like us to handle your paper? Use our company for better grades and meet your deadlines.


Order a Similar Paper Order a Different Paper

In this iLab, you will create an entity relationship diagram (ERD) for a portion of a database that a veterinary clinic might use to keep track of clients, veterinarians, patients, appointments, and procedures.

The major entities involved in this database design are listed below.

  • Clients (humans)
  • Patients (animals)
  • Veterinarians
  • Appointments
  • Procedures (veterinary procedures, such as tests or treatments performed during appointments)

Below are the business rules that apply to these entities.

  • Each Client owns zero or many Patients; each Patient is owned by exactly one Client.
  • Each Patient can have zero or many Appointments; each Appointment is for exactly one Patient.
  • Each Appointment is with exactly one Veterinarian; each Veterinarian can have zero or many Appointments.
  • Each Procedure can be performed during zero or many Appointments; each Appointment can include the performance of zero or many Procedures.

After completing the steps below, create a single Microsoft Visio file containing two diagram pages:

  • Conceptual: A conceptual data model diagram of this database
  • Logical: A logical data model diagram of this database

Your deliverable will be evaluated according to the rubric below.

STEP 1: Launch Visio and Create a Diagram

  • Launch Microsoft Visio.
  • Create a new Crow’s Foot Database Notation diagram.
  • Save the diagram using the file name iLabWeek2.vsd .

STEP 2: Create a Conceptual Data Model Diagram

  • Rename the first page of the diagram to Conceptual-ERD.
  • Use the Rectangle drawing tool to create and label a rectangle for each entity identified in the Scenario/Summary.
  • Add relationship lines connecting the entities as described in the business rules provided in the Scenario/Summary. Label each relationship line with a verb phrase describing the relationship.
  • Set the cardinality symbols on the ends of each relationship line to correctly denote the cardinality of each relationship, as given in the business rules.
  • Save your changes to the file.

STEP 3: Create a Logical Data Model Diagram

  • Insert a new page into the diagram and name it Logical-ERD.
  • Add Entity shapes to the page for each entity shown in the conceptual data model. Label each Entity shape with the corresponding entity name.
  • As you did for the conceptual data model, add relationship lines connecting the entities as described in the business rules provided in the Scenario/Summary. Label each relationship line using the same verb phrases as you used in the conceptual data model.
  • Set the cardinality symbols on the ends of each relationship line as you did in the conceptual data model.
  • Save your changes to the file.

STEP 4: Resolve the Many-to-Many Relationship

  • Remove the relationship line indicating a many-to-many relationship from the logical data model.
  • Add an Entity shape for an associative entity to resolve the many-to-many relationship. Label the associative entity with a meaningful descriptive name.
  • Add relationship lines connecting the associative entity to each of the entities involved in the original many-to-many relationship. Label each relationship line with a descriptive verb phrase.
  • Set the cardinality symbols on the ends of each relationship line appropriately.
  • Save your changes to the file.

STEP 5: Add Attributes, Data Types, Keys, and Normalization

  • Add appropriate attributes for each entity on the logical data model. Give each attribute a meaningful name. Follow a consistent naming convention for all attributes. You should have a minimum of three attributes for each entity (except possibly the associative entity).
  • Designate an appropriate primary key for each entity.
  • Designate appropriate foreign keys to implement all the relationships.
  • Review your completed diagram and ensure it is in at least third normal form (3NF).
  • Save your changes to the file.

This file will contain two diagram pages:

  1. Conceptual: A conceptual data model diagram of this database
  2. Logical: A logical data model diagram of this database

Your deliverable will be evaluated according to the rubric below.

Step Criteria Points %
2 Conceptual data model includes all entities with correct entity names and all required relationships. Correct cardinalities are indicated using crow’s foot notation. 10 20%
4 Logical data model includes the same entities and relationships shown on the conceptual data model. A many-to-manyrelationship is resolved using an appropriate associative entity. 20 40%
5 Logical data model includes reasonable attributes for each entity with appropriate data types, correctly designates all primary and foreign keys, and uses a visually organized and readable layout. 20 40%
Total 50 100%

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers. Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper