Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
CISC7203 – Database and Data Mining Technologies
Project 01 - Introduction
This course project aims to provide you with some experience in database design for a database application. This is a project with up to five people. In this project, you are required to select a domain which you are familiar with, then translate the theoretical concepts into the terms of a concrete DBMS to implement the database using MySQL Workbench (preferable).
Requirements:
A. Begin by choosing an application domain, e.g., the database for a local volleyball league or the database for a Society of Coffee Fans. Anyway, you should be familiar with the domain in order to have a professional design. It must be non-trivial, but not huge. As a general guideline, you should have about four to seven entity sets and a similar number of relationships sets in an ER model.
B. Description of the database information. Here you need to give the database information in natural language: talking about entities, attributes, keys, the nature of relationships between entities, any constraints, etc. You may have some reasonable assumptions for your application. For example, in the university database discussed in class, the assumptions were:
-
Instructors must belong to one department.
-
Students must belong to one department.
-
Instructors teach courses, students takes courses.
-
Instructors have an ID, name, department and salary.
-
…
C. Construct an E-R diagram, which will reflect your choice of the entity sets, their relevant attributes, and the relationships between them. Again, make your relationshipsrealistic and meaningful. That is a formal modeling the database requirements. The ERmodel should be self-explainable or with some necessary explanations for unclear notations in the model.
D. Convert the E-R diagram into a relational database schema.
E. Create your schema in SQL.
F. Insert at least 5 records into each table.
G. List at least 5 reasonable queries. For each query, write it in natural language, together with SQL statements and its query results.
Report deliverables - Submit a report containing the following sections:
A. A short description of your chosen domain or database application (no more than 500 words).
B. In natural language, give descriptions of entities, relationships, attributes, keys, constraints, and so on. Provide information about your relations.
C. Give the ER diagram of your database and the schema diagram after reducing it to relational schemas. (as in our PPT).
D. Give DDL of those tables. Create a script.
E. For each table, print its results using select *. The results should be included in the report.
F. Each query should be in natural language, together with its SQL statement, followed by its query result.
Report submission:
The name of your report should follow the format “Report01Gr” +<group number>, e.g., Group #01 will name its report as Report01Gr01.
Submit the scripts: Your design will be checked to see if it can really work as you claim in your report.
Name scripts with similar format as the report. If you have two scripts, name them as Script1Gr01.sql, and Script2Gr01.sql.
Submit the report and scripts at UM Moodle. Only one student per group is required to upload the project.