Question
I need help completing this
blRx tblDrug PrescriptionID UPN CustiD UPN Name 66 22 566 Quentix 972 Rivashigmine fortrale The record kr UPN 366 Cascode Delete Related Records option deletes all matching records in tbRx deleted from tblDrug Steps To Success: Level 2 and table relationships You have learned a great deal about database objects, concepts, a requisite knowledge for planning a relational database. Now it is time to c which database objects are required for the 4Corners Pharmacy database and how to rclate the tables On a piece of paper, complete the following 1. Although the 4Corners Pharmacy database might ultimately include additional tables, it will include tables for the following entities: customers, prescriptions, drugs doctors, clinics, employees, job titles, and training classes. Given these tables, descnb five queries, two forms, and three reports that managers at the pharmacy might create and describe how they would use them in the pharmacy's day-to-day operations 2. What are some examples of using worksheets instead of a database that you have used? How would a relational database simplify the work you needed to complete 3. What primary keys might you assign to tables that store data about the following entities: customers, prescriptions, drugs, doctors, clinics, employees, job titles, and training classes? Describe why and how you chose the primary key for each table. 4. Suppose that tblDoctor includes the fields DoctorlD, DoctorFirst, DoctorLast and Phone; and tblClinic includes the fields ClinicID, ClinicName, Address, City State, ZIP, and Phone. Is there a common field: Is there a foreign key? What kind relationship might you create between these two tables? TROUBLESHOOTING: In order to successfully complete this task, begin by reviewing the tables, and then decide which fields can be related between the tables If necessary, create any new field within the tables so that they can be related to other tables 78
Explanation / Answer
3. primary key is an attribute that identifies each row in the table uniquely.
each customer will have an id given by hospital
a prescription will have unique number
drug name itself can be used as primary key.
each doctor will have a unique ID
a clinic have a registered ID that can be used as primary key.
an employee has a unique id
job title can be used as primary key.
treaining subject name is used as primary key
4 . as per the information given in question there is no common field between tables. therefore there is no foreign key. a foreign key will be present only if there is a common field between tables. so we cannot have any relationship between these tables.
*****************END**********************PLS GIVE ME GOOD RATING*************************************************
