Simple microsoft access project

The Database design project carries a weight of 20%. After thoroughly understanding the principles and methods of designing a database, you should select a specific area/topic for your database. Database project is due in 3hours Design a database using MS Access with the following specifications (at least): 1. Create appropriate tables (you should have at least 5 tables) and identify relationships. 2. Identify clearly the primary and foreign key (s). 3. Data should be entered using a data entry form. 4. Design queries that ask for user input (i.e., ask for a patient id to retrieve patient information.) 5. Generate a report on your database to answer questions (for example, how many patients were hospitalized due to cardiac problems) 6. Design queries to retrieve information from multiple tables. 7. After any update or manipulation, you database should maintain referential integrity. Example database project: Scenario: Assume you are a new person hired to create and maintain a small hospital patient database. The hospital has the following scenario: Patient visits the hospital. First, patients have to register with the registration clerk, where the clerk records patient demographics (name, id, address, gender, race etc.). Then they are called by an assigned nurse to record information such as body temperature, blood pressure etc. After that they will see assigned doctor. Depending on situation, doctors may or may not admit patients for inpatient services. Doctor provides new prescriptions for patients and records all the medications that a patient is currently taking. Each medication has start date as well as end date and physician information who prescribes the medication. Doctor may also order laboratory works for the patient. Laboratory attendant updates the lab test results for each of the patients with proper order and information. Design a hospital patient management database with tables for each of the proper entities (patient, medications, hospital staff, lab test, hospitalization of patients, doctor information, prescriptions etc.). For each patient’s visit, patient should have a primary diagnosis (reason for visit) also. Populate your tables with appropriate dummy data (make up your own data). This is just a sample to give you an idea about how your database project should be. You can choose this for your project if you want to. You are welcome to choose your own project for different settings (other than patient management). Please let us know about what you choose and a brief description of what you are going to do for the project. What to submit (Due: in 3hours): – A detail description of your project – Diagram of your database including tables with attributes and relationships. – SQL for queries. – Screen shots of the queries and results (at least for specifications 4,5 and 6 mentioned above) – Your database project in MS Access (the .mdb file)