Lab Assignment 3 DBA110 For each of these problems, produce a crows foot ERD. Make sure the ERD includes primary keys, foreign keys, and attributes. You must create the diagram using Microsoft Visio. 1. Soapscum Window Washing wants to keep track of its employees and the projects to which they are assigned. They need to keep track of some basic employee contact information, such as name, email address, and phone number. They use job classifications to group employees and determine salary. A classification has a code, description, and salary. Each employee is assigned to a single classification, and there can be multiple employees within the company assigned to a classification. In addition, they would like to keep track of all the projects to which each employee is assigned. For each project, there is an id number, a start date, an end date, and a cost. Each project can have multiple employees assigned to it, and an employee can be assigned to multiple projects. 2. Lame Events puts on athletic events for local athletes. They would like to have a database, including things like the sponsor for the event and where it was located, that can keep track of these events. For each event, they need a description, date, and cost. Separate costs are negotiated for each event. They would also like to have a list of potential sponsors that includes each sponsors contact information such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event over time. They also need a master list of locations such as running tracks and stadiums and phone numbers. A particular event will use only one location, but a location may be used for multiple events. 3. Using the Crows Foot design, create an ERD that can be implemented for a medical clinic, using the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and 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 the appointment book as unscheduled. c. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. d. With each visit, the patients records are updated to provide a medical history.

Lab Assignment 3 DBA110 For each of these problems, produce a crows foot ERD. Make sure the ERD includes primary keys, foreign keys, and attributes. You must create the diagram using Microsoft Visio. 1. Soapscum Window Washing wants to keep track of its employees and the projects to which they are assigned. They need to keep track of some basic employee contact information, such as name, email address, and phone number. They use job classifications to group employees and determine salary. A classification has a code, description, and salary. Each employee is assigned to a single classification, and there can be multiple employees within the company assigned to a classification. In addition, they would like to keep track of all the projects to which each employee is assigned. For each project, there is an id number, a start date, an end date, and a cost. Each project can have multiple employees assigned to it, and an employee can be assigned to multiple projects. 2. Lame Events puts on athletic events for local athletes. They would like to have a database, including things like the sponsor for the event and where it was located, that can keep track of these events. For each event, they need a description, date, and cost. Separate costs are negotiated for each event. They would also like to have a list of potential sponsors that includes each sponsors contact information such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event over time. They also need a master list of locations such as running tracks and stadiums and phone numbers. A particular event will use only one location, but a location may be used for multiple events. 3. Using the Crows Foot design, create an ERD that can be implemented for a medical clinic, using the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and 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 the appointment book as unscheduled. c. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. d. With each visit, the patients records are updated to provide a medical history.