DATABASE MANAGEMENT SYSTEMS PROJECT.

You DO NOT have to use Access but you must create the tables, queries, forms and reports. NOT handwritten. Since the SQL is already written this project should be simple.

Examine the Relational Schema that was created during the Phase I of the project.

• Based on that schema, create a set of tables for an MS Access database (or other database). Name the database and its tables appropriately. Make sure to specify primary keys for all tables. Make sure all referential integrity constraints are enforced.
• Create all the necessary relationships between the tables. (i.e. primary keys to foreign keys)
• Populate the tables with initial data (no less than two no more than ten records per table).
• Create at least two queries for this database. Give a statement of what the queries are supposed to be answering. Explain why you chose to do these queries.
• Create at least two forms for this database. (You can base your forms on tables, queries, or both). Describe how to use the forms. What information should be entered? Why you chose that information to be entered?
• Create at one reports for this database. (You can base your reports on tables, queries, or both). Describe the reports. What are the reports trying to give information about? Who is the targeted audience?

Dentist DentistID Name Phone Experience Patient PatientID Name Address Phone Age Personal_DentistID (FK) Appointment AppointmentID Date Time AppointmentNote DentistID (FK) Patienten (FK) Prescription PrescriptionID Date TotalAmount AppointmentID (FK) Prescription Drugs PrescriptionID (FK) DrugID (FK) DosePerDay Drugs DrugID Name AlergyNote CostPerUnit