Question: Hemework 1 Instractions Develop an entity relationship diagram based on the provided informatioa and following the steps below: A small medical clinic necds a relational

 Hemework 1 Instractions Develop an entity relationship diagram based on the

Hemework 1 Instractions Develop an entity relationship diagram based on the provided informatioa and following the steps below: A small medical clinic necds a relational database for its medical practice. The database necols no follow the basiness rules and requirements: - Databuse needs to store data about patients, doctars, and their appoinetments. appointwent is made with anly one doctor and ane patient at a time - An appointment yields a visit with the doctor. Datahase monds to store data about allocie viuis. - Affer each patient visit, an imvice is generated. Database necels io shore data aboet these imvoices: - A parient pays imoices and database neculs no stare data about these poymontx A putiont poys each imoice in ane or more payments; each poymment is associatnd with one imoice. Sieps: L. Ldentify necessary entities, relevant attribates of the entities, and relationahips between entities in this database. Then put these together to create as ER diagram. Besides the peimury key columan, and foreign key columns (as necded), please be sure that the following attributes are alwo incloded in appropriate cntities in your ER diagram: Names of doctors and patients along with their phene aumbers; appoimenent date and time; visit date and visit time; date and amount of invoice; date abd amosant of payment teccived and any other necessary attributes. 2. Resine cach entify and make sure that all of the attributes in it are visible. 3. Add a text box nett to your diagram and display your full name (Fint-aume Last-aume) in it. 4. Save and submit your work as instructed below: 1) From the menu, seloct File > Save Model As. 2) Name the file using your last name 3) Save the file as MySQL. Workbench Models (mab file). 4) Exit MySQL Workbeoch software. 5) Upload your your-layi-name mub file no Canvas ander Homesork 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!