you are required to complete a group project, which is to implement a relational database the purpose of the project is to exercise database concepts in realistic contexts.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

During the semester, you are required to complete a group project, which is to implement a relational database. The purpose of the project is to exercise database concepts in realistic contexts.

The requirements of the group projects include:

1. Your database system must support certain business areas or processes. You are required to choose one of the organizations listed in Appendix A at the end of this document. Each group must select a different
2. You do not need to implement the whole database of the selected organization. Define some functions and processes in the organization and design a database for these functions and processes.
3. Your database system must contain at least 4 tables and should not exceed 10 tables. Front-end applications are not required.
4. You must use MySQL for database design and
5. Define some reporting requirements and implement them in
6. Each group contains 3

Project components, schedule, and grading scheme:

• Proposal (2 points): submit to instructor in class on May 29, 2019
• Design and Implementation (13 points): explained in your project reports and demos
  • business rules
  • conceptual design
  • logical design
  • physical design
  • reporting design and SQL

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of