doudareva - Group Members: Evgueniia Doudareva 995403558,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Group Members: Evgueniia Doudareva 995403558, Hani Omara 995303283 The work being submitted by all the individuals in the group is their exclusive work as a group. I consent to make available the application developed through Assignments 1 and 3 (not including my stud Application Description. ------------------------ The given E/R diagram is provided in order to illustrate the entities and the corresponding relationships wi The entities are Drugs, Manufacturer, Status, Y, N, Active Ingredients, Non-Medical Ingredients, Human, V Entities -------- Domains: DrugCode: char(8), DIN: char(8), GP_Flag: char(2), Accession Number: char(5), last Update: char(6), num Key (Drug Code, Active Ingredient Code) Domains: DrugCode: char(8), Active Ingredient Code: code, Ingredient: String. Domains: Drug_Name: String, Common_uses: String, How_to_use: String, side_effects: String Key: Drug_Name REF Drugs(Category) Domains: DrugCode: char(8), Manufacturer: String, City: String, Province: String, Country: String. Domains: DrugCode: char(8), Status: status(check Status = "Y" or "N"), Date_Of_Status_Change: char(10). Domains: DrugCode: char(8), Class: class(check Status = "Human"), Sex: sex(check Sex = "male" or "female"). Domains:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

doudareva - Group Members: Evgueniia Doudareva 995403558,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online