HND Database Design and Development Assignment

INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY




Assignment Cover Sheet

Qualification Module Number and Title
HND in Software Engineering SEC4205/Database Design Development
Student Name & No. Assessor
Dilshan S

Hand out date Submission Date
04/12/2017 28/12/2017
Duration/Length of
Assessment type Weighting of Assessment
Reports 5000 Words Assessment Type 100%
One Month


Learner declaration


I certify that the work submitted for this assignment is my own and research sources are fully
acknowledged.



Marks Awarded
First assessor

IV marks

Agreed grade

Signature of the assessor Date




Database Design & Development
1

, INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY


FEEDBACK FORM INTERNATIONAL COLLEGE OF
BUSINESS & TECHNOLOGY
Module/Title: Database Design and Development /Design a Database Management System for a
private Team Tech construction firm
Student: Dilshan Sameera
Assessor: Chamila Attanayaka

Assignment: Database Development &
Design



Strong features of your work:




Areas for improvement:




Marks Awarded:




Database Design & Development
2

, INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY




Acknowledgement

During this assignment many people help me to success the work and I would not forget to
thank them. So I firstly respect and thank Mrs. Chamila Attanayake madam, for providing me
an opportunity to do this work and giving us all support and guidance which made me complete
the assignment successfully. And also I extremely thankful to him for providing such a nice
support and guidance.

And I am also thankful to my friends who helped me by sharing their knowledge and
experience in the process of learning.

Thank you!




Database Design & Development
3

, INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY




Executive Summary

This is about the database management system. In here we have to create a database in a proper
way for the company called “Team Tech”. And it is a private construction firm at Colombo.
So in this assignment, first we discussed about the data models and benefits and disadvantages
of them. Then explain about different types of technologies use for the databases. After that we
have to identify the attributes, entities, cardinalities and all, with the scenario and draw ER
Diagram for the company.

We created this database using SQL Server management studio, and visual studio use for create
management reports for the company. We already added relational schema. And also we added
User manual for how to use the database, then testing part is already done. In final task we
discussed about how to verification and validation address to the database and some details
about access rights for the users.




Database Design & Development
4

, INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY


Table of Content



Acknowledgement .................................................................................................................... 3

Executive Summary ................................................................................................................. 4

Table of Content....................................................................................................................... 5

Introduction ............................................................................................................................ 10

Task 01 .................................................................................................................................... 11

1.1. What is a Data model? ............................................................................................ 11

1.2: Different types of data model .................................................................................... 12

1.2.1: Hierarchical Data Model .................................................................................... 12

1.2.2: Network Data Model ........................................................................................... 14

1.2.3: Relational Data Model ........................................................................................ 15

Task 02 .................................................................................................................................... 18

2.1. Different types of database technologies ............................................................... 18

2.1.1. SQL Server ....................................................................................................... 18

2.1.2. Oracle data base engine ................................................................................... 20

2.1.3. MySQL data base engine................................................................................. 20

Task 03 .................................................................................................................................... 23

3.1. ER Diagram for the Team Tech Company ........................................................... 23

Task 04 .................................................................................................................................... 25

4.1. Relational Schema for the Team Tech Company ..................................................... 25

4.2. Database Diagram ....................................................................................................... 26

Task 05 .................................................................................................................................... 27

5.1. Write SQL Queries for given questions .................................................................... 27

Question No 1: List of names of all Engineers who attached to a particular
project .............................................................................................................................. 27



Database Design & Development
5