MCIS 5133 | Submit a Project Report | Database Project

In this project you will design a database information system for an institution (a company, school, supermarket, video store, etc.) of your choice. You should work on this project in teams. Each team consists of three to five students.

Choose any DBMS software to implement your project.

You have to submit a project report by the end of the last week of this semester.

The project report should effectively communicate everything that you have done in the project. It should describe the problem / environment, what you proposed to do, the scope of the project, and of course everything from the diagrams to the final queries. Importantly, the final project report should stand out a one integrated work.

The project report should specifically include the following:

• Project definition, scope

What is underlying the problem that the database addresses?

Who will be the users of this database?

What kind of data is to be stored in this database?

Will there be any constraints on the data that will be stored in this database? Why?

What real world scenarios will this data represent (i.e. what are the kinds of transactions that you can think of that will take place with your database)?

What kind of information would you expect to retrieve from this database, e.g., the kinds of reports that the various kinds of users might like to see? Or the queries that they would like to run?

What will be the integrity constraints that you can think of? Why?

In what ways do you think your project will give your company competitive advantage?

                                                                                                                              

• ER and/ or EER diagram
• Definitions

Entity definitions for all entities in the EER diagram

Relationship definitions for all relationships in the EER diagram

Attribute definitions for all attributes in all entities

• Map the EER diagram to a relational schema illustrating referential integrity
• Diagram the functional dependencies on the relational schema
• Develop a set of 3NF relations
• Write SQL queries for your database.

You should write at least 5 single-table queries.  These queries should serve some business function

You should write at least 5 multi-table queries.  These queries should serve some business function

• List of all queries and a brief explanation of the purpose of each query
• Output of all queries and any additional features that you may have included that enriches the project
• Basic description of your database tables.