Data Analysis and Design: A Comprehensive Guide to Database Technologies and Design Approaches

DATA ANALYSIS AND DESIGN

Contents
Introduction......................................................................................................................................3
LO1 Understand data models and database technologies................................................................4
1.1 Critically compares different data models and schemas...................................................4
1.2 Critically discusses the benefits and limitations of different database technologies........9
1.3 Analyze different approaches to database design................................................................12
Reference:......................................................................................................................................15
List of Figures
Figure 1 Top-down approach.........................................................................................................12
Figure 2 bottom-up approach.........................................................................................................13
Figure 3 conceptual ER diagrams of Dominican College.............................................................13
Figure 4 Logical diagram of the Dominican college.....................................................................14

Introduction
The database is a most important part of the digital life, which is used to store different types of
the data in the form of table. Main advantage of the database is that user can access the data and
information according to requirement and it is used to reduce the redundancy of the data and
information. The database is used to maintain the dataset. According to the scenario, the
Dominican College wants a database system and this college is located 15 miles northwest of
New York City. The college wants a database system to allocate the lecture to the students
according different course and units. But main problem is that they are not using any centralized
database system to manage different courses. The main aim of this report is to design a
cauterized database system for Dominican College to access the data and information according
to requirement.

LO1 Understand data models and database technologies.
1.1 Critically compares different data models and schemas.
Data model: The data model is used to define the data structure of the database. The data models
are used to introduce the abstraction in the database management system. It is used to provide a
way to connect the data and it is used to provide a way to store the data in the system. There are
different types if the data model in the database management system. The description of the
different data models are providing in this session. The data modeling is a process which is used
to create a document of complex software system design. Different data model are given below:
 Entity relationship model.
 Relational model.
 Object-oriented model.
 Network model.
 Hierarchical database model.
Entity relationship model:
Entity relationship model is a type of the data model in the database management system. the
Entity-relationship model is known as ER model. There is two main component in this model
and they are an entity and their relationship. The ER model is fully dependent on the entities and
relations. The set of the entity and relationship is created by the entity relationship model.
Entity: The entity relationship model contains different real-world entities. The entity contains
some properties and the properties are known as attributes. The attributes of the entity can be
referred as a set of values. For example, the database contains different entities like students,
teacher, course, class etc. and the student entity contains some attributes like student name,
student roll number, address, contact number, father name and mother name etc.
Relationship: the relationship is a way to connect different entities together. There are different
types of the relationship and they are following:
 One to one relationship
 One to many relationships