Reference no: EM13942689
Database Design Script Assignment
To satisfy the requirements for this assignment, complete the following steps:
1) Consider the following scenario: A small doctors office has three physicians, each of whom see many patients each day. The office is patronized by more than 500 different people, some of whom have come in for many appointments over the years, some of whom have only come in once and never returned. If a new patient sets up an appointment, any of their family members are also added to the clinic's database, just in case they schedule an appointment at some point in the future. Each appointment must keep track of date and time, who the appointment is for, which doctor will conduct the appointment, when the appointment was complete, and if the doctor recorded any notes from the appointment. Doctors may also write prescriptions for patients in association with the appointments. Not every appointment will result in a prescription being written, but some appointments will have two or more prescriptions written for a patient.
2) Using draw.io (Links to an external site.) (or another ER diagramming tool if you prefer and have access to it), create an Entity Relationship diagram for a database that would support the clinic's data needs, as described in step #1 above. Be sure to include Entities, Attributes, Data Types and Relationships with appropriate referential integrity. Create a Microsoft Word document and either place a screenshot of your ER diagram or embed your ER diagram into the Word document.
3) Below your ER diagram, write a DDL script in SQL Server syntax that will create your entities and their attributes (with data types), define keys, and enforce referential integrity.
Save and submit your Word document to Canvas by the due date.
I need help creating an ER diagram based on the above requirements.
|
How long would it take to melt the paraffin
: How long would it take to completely liquefy the paraffin, from an initial state for which all the paraffin is solid and at 27.4°C - How long would it take to melt the paraffin for m = 0.5 kg/s?
|
|
Is there a way to create audit standards
: What type of audit appears to be the most useful in organizations? Since computer systems are becoming used in greater capacity within organizations, how should audit standards be improved to reflect this more complex integration?
|
|
Importance of charting and graphing
: After you view the video from this week's Reading, you are going to develop your own math or science activity. This activity should focus on change and the importance of capturing change and growth. For example, you could develop an activity aroun..
|
|
Assignment on photography in canberra
: Do an assignment on photography in canberra. It is about opening a new businesses and analysing different factors including pestel.
|
|
Database design script assignment
: 1) Consider the following scenario: A small doctors office has three physicians, each of whom see many patients each day. The office is patronized by more than 500 different people, some of whom have come in for many appointments over the years, some..
|
|
Describe health hazards associated with workers
: Describe the health hazards associated with workers inhaling cotton dust in this cotton-processing facility. Describe potential exposures to chemicals that may be used in this factory.
|
|
New-hire training for new insurance agents
: Scenario: An insurance company has hired you to do an evaluation of its training program. Members of management are particularly concerned about the new-hire training for new insurance agents.
|
|
Challenge facing organzational leaders
: Employee engagement is acknowledged as a strong predictor of employee and work until performance. The challenge facing organzational leaders is that most employee are not very engaged
|
|
Planning & implementing a data warehouse project
: ABC Industries is a diversified global organization that provides a variety of services, including financial and technical, and manufactures its own numerous products. Its manufacturing base is spread across the globe. ABC's production facilities ..
|