Database schema

Tables list

1. Amount-Sold

2. Quantity-Price

3. Cost

4. Product-Name

Context:

The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It

also introduces you to some of the key features of database management system and designing

database systems that will feature in later modules of this topic. In order for you to do well in this

subject, it is imperative that you undertake all of the learning activities in the modules. The learning

activities are presented as a way of scaffolding your learning so that you can attempt the building

Part 1: Design the Database

The first phase of the project involves the design of the database.

In this phase you need to design a database that maintain all the "Contracts" of a company. The

Contract Management System (CMS) will serve the employees, managers and other stakeholders

in the enterprise. You should use MySQL DBMS to implement the database system and show its

execution by queries.

Problem Statement: