Janavar Database

Model and Implement the Janavar database based on the information given below in form of reports

• Extract and Design a relational model using ER/EER
• Determine the primary keys. This step is done normally while creating ER/EER.
• Set up relationships (determining foreign keys) by mapping your ER/EER to relations and showing what are FK and PK in your relations.
• Implement the database on DBMS of your choice. DBMS example: MySQL, SQL server, Oracle, DB2, If you have no access to any DBMS, ask for a Database Server account at Univ.
• Design the SQL-statements that are used as a basis to create the original reports and other queries that include the following (at least):
  • A SELECT using an inequality
  • A SELECT using LIKE on a text field
  • A SELECT on a DATE column
  • A query using GROUP BY
  • A query using HAVING
  • A query using ORDER BY
  • A query using a subquery
  • A query using a correlated subquery
  • A query involving COUNT(*)
  • A query involving another aggregate function
  • A selective DELETE
  • A selective UPDATE

Preparation:

Before you start with the actual design, take a piece of paper with a pencil and try to find out what the may be entities could be by examining the printouts given below , you are free to add extra relevant information if you think your database should cover. When finished with all the information you can get from the report, start design your ER/EER- diagram and the rest of steps given above. Before you implement the final database with SQL on a DBSM, try with some test-tables.

Remember that database design is the art of discussion, logical thinking and constructive fantasy!

Customers and Pets. see image.

Daily Visits Report. see image.

Hospital Employees. see image.