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
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
Get step-by-step solutions from verified subject matter experts
