BIS245 DeVry Week 4 Database Essentials With Lab

timer Asked: Jan 25th, 2021

Question Description

I'm working on a databases project and need support to help me learn.

Good Day,

I am seeking someone to assist me with a course project; you will need to have access to as well as create a diagram in Microsoft Visio 2019. Attached are the following which will be required to complete the project: 1) case study zip files which includes the following attachments appointments.xlsx, doctors.txt and patients.xlsx 2) scenario and instructions are on a separate attachment

Unformatted Attachment Preview

Scenario (please see case study files that will be used to create database; these are in additional attachments). Those attachments are appointments.xlsx, Doctors.text, and Patients.xlsx A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors and appointments, using the following business rules: • • • Patients can have many doctors and doctors can see many patients. Doctors can have multiple appointments with patients (but only one patient at a time). Remember that many-to-many relationships need to have associative tables between them. That is, since the relationship represents a specific doctor and a specific patient at a specific time, you need an entity that represents that instance (the appointment). Otherwise, you won't be able to track individual appointments. Instructions 1. Please identify the attributes and primary keys needed for each of the entities. 2. Identify the data types you would use for each of the attributes. 3. Determine the relationships between the entities and find the one-to-many and manyto-many relationships. 4. Create an ER diagram using Visio include the associative tables based on your analysis. 5. Identify all foreign keys needed in the database design. Please make sure the below deliverables are met in accordance with the above instructions. 1a. Primary key identified for each entity (three tables): patients, doctors, appointments 1b. Attributes identified for each entity (three tables): patients, doctors, appointments 2a. Identified data types 3a. Identify one-to-many relationships 3b. Identify many-to-many relationships 4a. Add foreign keys to tables as needed 5a. Create an ER diagram using Visio ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors