Assessment - Design and Development of a Database System

ASSIGNMENT OBJECTIVES:

1. To develop/analyse a set of requirements for a database system.

2. To develop an ERD and a normalised schema.

3. To implement the database system in SQL Server.

Details of assignment brief

Assessment Task

You are required to develop the design of a database system for a company/business of your choice.

The implementation of your system must be carried out using MS SQL Server. As part of the assessment, you are required to submit the following:

Report

The report must include the following:

- Background for the development of the chosen database system. (Why the Database is needed) Scope including requirements for the database system to be developed. (What should it be able to do)
- Description of at least 3 business rules and their implementation.
- An Entity Relationship Diagram (ERD) of the system which must include a minimum of 6 entities displaying all the relationships with cardinalities and all the constraints.The model (relational schema) of your database system that must fulfil the requirements of 3NF. Use Draw.ioto develop the ERD.
- Evaluation of your database design, highlighting the strengths and weaknesses.
- Appropriately structured report showing precise information. (Cover page, Table of Contents, Headings etc)
Completed Database System (Using MS SQL Server Management Studio)
Consider the ERD created and ;
- Create the relevant tables with appropriate relationships in MS SQL Server using the CREATE TABLE statement.
- Ensure appropriate Data types are used.
- Populate the tables with a minimum of 5 records using INSERT INTO SQL Statements.
- Create a data diagram and include it in the appendix of your report.

- Create 3 Stored Procedures. The Following must be included
o List all items from any table in order of some attribute
o Data from 2 tables
o Use of "DISTINCT" operator
(8 Marks)

- Create the followingparametric stored procedures :
o Search between two dates
o Use of the "LIKE" operator
o A parametric Stored Procedure that would support the business

- Create a View that would be beneficial for the business.

- Scripts for your SQL server database for structure and data.

Attachment:- Design and Development of a Database System.rar