Description
BIAM 530 Week 2 Lab Relationships and Normalization DeVry
Lab Overview
In this Lab, 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.
Deliverables
After completing the steps below, submit it as a single Microsoft Visio file named LabWeek2xxx.vsd (where xxx = your initials). This file will contain 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 | 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-many relationship 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% |
Required Software
Microsoft Visio
Access the software at https://lab.devry.edu (Links to an external site.)Links to an external site..
Tutorial
The following tutorial will demonstrate, in general, how to use Microsoft Visio 2016 to create an entity relationship diagram (ERD). IMPORTANT: The ERD created in the video is NOT the ERD you will create in this lab. Please watch the video to gain an understanding of how to work in Visio, but follow the written steps below to create the correct deliverable for this Lab activity, based on the Scenario/Summary given at the beginning of this page.
Lab Steps
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 LabWeek2xxx.vsd (where xxx = your initials).
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. To add data types, right-click the entity shape while pointing to the entity outline. Select the “Show Attributes” option. 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.
STEP 6: Discussion of the Process
Write professional report to present your recommended database design and explain to your CEO why you are recommending this design.
Step 7: Submit Work
Submit your work to Canvas. There should be one MS Word file with Step 6 Report and Screen Prints, OR One MS Word Document with Discussion and one MS Visio file with drawings.
Course Tutor helps in providing the best essay writing service. If you need 100% original papers for BIAM 530 Week 2 Database Design DeVry, then contact us through call or live chat.
BIAM 530 Week 2 Lab Relationships and Normalization DeVry
![Best BIAM 530 Week 2 Lab Relationships and Normalization DeVry](http://coursetutor.us/wp-content/uploads/2018/05/eb-10.png)
ACCT 553 DeVry, BIAM 500 DeVry, CIS 500 STR, CIS 558 STR, ENG 105 GCU, FIN 390 DeVry, FIN 504 GCU, HCA 545 GCU, HCA 699 GCU, HLT 306 GCU, HLT 362 GCU, HLT 555 GCU, HLT 610 GCU, HLT 665 GCU, HOSP 594 DeVry, HRM 600 DeVry, MAT 144 GCU, MGMT 600, MGT 599 STR, MGT 655 GCU, MKT 373 GCU, PSY 362 GCU, PSY 565 GCU, PSY 575 GCU, PSY 665 GCU, SOC 102 GCU, SOC 320 GCU, SOC 372 GCU, SOC 412 GCU, NSG 6440 SU, HIM 515 GCU, NSG 4029 SU, HIM 615 GCU, NSG 3029 SU, NSG 4055 SU, NSG 6630 SU, NSG 6005 SU, CRMJ 310, PSY 510 GCU, CRMJ 300 Devry, CRMJ 425, SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCU, MGT 640 GCU, CIS 527 STR, SOC 436 GCU,ACC 502 GCU, FIN 504 GCU ,MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVry, NETW 203 DeVry, NETW 205 DeVry, ECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU ,BIAM 570 DeVry, PSY 402 GCU , SOC 480 GCU , BIAM 530 DeVry
Reviews
There are no reviews yet.