logo

Database Design

This assignment concerns database conceptual modelling, logical design and implementation for an advertising agency called Shine.

10 Pages914 Words34 Views
   

Added on  2022-12-22

About This Document

This document discusses the importance of database design and provides an overview of the conceptual and relational data models. It also explores functional dependencies and provides sample queries. If you need assistance with database design assignments or essays, Desklib is here to help.

Database Design

This assignment concerns database conceptual modelling, logical design and implementation for an advertising agency called Shine.

   Added on 2022-12-22

ShareRelated Documents
Running head: DATABASE DESIGN
Database Design
Name of the Student
Name of the University
Author Note
Database Design_1
DATABASE DESIGN1
Table of Contents
Introduction................................................................................................................................2
Conceptual Data Model..............................................................................................................2
Relational Data Model...............................................................................................................3
Functional Dependencies...........................................................................................................4
Queries.......................................................................................................................................5
Conclusion..................................................................................................................................8
References..................................................................................................................................9
Database Design_2
DATABASE DESIGN2
Introduction
The relational database managements system is a collection of interrelated data. The
report indents to deal with the conceptual modelling of the given case study about a company
named shine. The conceptual model is consist with the Enhanced Entity-relationship
Diagram. Along with, the relational (logical) model is developed by Entity-relationship
Diagram (Connolly and Begg 2015). In the later sections of the report the Data manipulation
language scripts are used to resolve the provided queries along with the screenshot of the
output.
Conceptual Data Model
Conceptual model of a database is the most basic and abstract level of designing
(Krogstie 2013). Other implementation information or unnecessary procedures are eliminated
from this model to develop the logical model.
Database Design_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
ISYS224 2019-Assignment 1
|31
|4487
|265

Data Modelling: Conceptual, Logical and Physical Models
|16
|2565
|499

Database Implementation
|38
|5094
|79

Database Systems and Design - PDF
|28
|1779
|95

Database Model Design
|10
|2343
|341

Database Design & Development TABLE OF CONTENTS
|31
|5485
|361