Assessment Details

JC Consulting is offering digital consulting business services. The company provides a wide range of

services from developing websites to back$-$end database programming. The founder of JC Consulting,

James kept track of his clients and project information in a spreadsheet. Due to the company's recent

growth, it is no longer feasible to use spreadsheets to maintain data. To address these challenges and

support continued growth, JC Consulting decided to transition from spreadsheets to a robust database

management system. You are hired to design the comprehensive database system that will effectively

store and manage the data.

Refer to Figure $1$: project estimate spreadsheet and Figure $2$: project estimate receipt for your

reference to construct the database. You also need to state the assumptions you make if they are not

given in the requirements. Requirements

The assignment should be presented in a report format including the following sections.

$1.$ Design and Develop an ER Diagram in Crow$$s foot notation with all the entity names, attribute

names, primary keys and foreign keys, relationships, cardinality, and constraints indicated.

You can add entities or attributes as you see fit. A minimum of $6$ entities is required. All manyto$-$many relationships must be resolved.

$2.$ A list of relationships with all entities, attributes, and primary and foreign keys indicated as

per the conventions given in the webinar slides $($i$.$e$.,$ entity$/$table names in capitals, attributes

as proper nouns, primary key underlined, and foreign keys in italics$).$

$3.$ A discussion on normalization, the normal form that each entity is in$,$ how normalization was

achieved, and why that is optimal.

$4.$ A Relational schema indicating the type and purpose of all attributes.

A suggested structure for the report is given below:

Title page

Table of Contents

Chapter $1.$ Introduction

Chapter $2.$ ER Diagram

Chapter $3.$ Normalization

Chapter $4.$ Relational Schema

Chapter $5.$ Conclusion

ReferencesFigure $1$: Project estimate spreadsheet

Figure $2$: Project estimate receipt.