Essay
HND Database Design and Development Assignment
- Course
- Institution
I got a Distinction for this assignment.
[Show more]
Seller
Follow
samrupasinghe
Reviews received
Content preview
INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGYAssignment 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller samrupasinghe. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $3.94. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
58716 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 15 years now