Question: You might find the same post with the same table but my first post was answered with an incorrect answers thats why Im reposting it

You might find the same post with the same table but my first post was answered with an incorrect answers thats why Im reposting it
 You might find the same post with the same table but
my first post was answered with an incorrect answers thats why Im

Max Score: 75 This table has information on all current prescriptions P- Prescription Table- Field Name Field Type Description Dru SSNum NumDays TabDay Name of the Drug/Tablet Social Security Number of Patient Number of Days the patient has to take the tablet for Char Char Numeric Numeri c Number of tablets to be taken each day by the patient Sample Table SSNum 123-56-9876 123-56-9876 234-56-7890 345-67-8901 NumDays 15 TabDay Drug Prozac Asprin Terramycin 10 Prozac D- Drug Table - This table has information on all available dru Field Name Tablet Manu UP Reaction Field Type Description Char Name of the Drug/Tablet Char Numeric Unit Price per tablet for the drug Char Name of the manufacturer of the drug Name of a drug that can NOT be taken along with the current drug. Sample Table Tablet Prozac Terramycn Manu Abbot Pfizer Baxter Abbot UP Reaction 6.75 2.75 Asprin 0.35 Terramycin 1.05 Imodium C- Customers/patients Table- This table has information on all customers/patients Field Name Field Type Description Name Char Char Name of the customer/patient Social security number SSNum DOB Numeric Date of Birth Char City in which the person live ity Sample Table Name John Doe Paula Smith Peter Green Sally Blue Note: DOB City 05/23/1960 Chicago 12/07/1970 River Forest 01/31/1980 Oak Park 07/07/1998 Chicago SSNum 123-56-9876 234-56-7890 345-67-8901 456-78-9012 These tables are only samples. The actual tables can have a lot more records in the The queries you write should always work, regardless of the data currently in the ta bles

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 Databases Questions!