UNIT 2 CREATING
SYSTEMS TO MANAGE
INFORMATION
David Ivan Lemke
MARCH 31, 2022
UKCBC
Level 3 IT
,Table of Contents
Introduction............................................................................................................................2
Explain how the features of a relational database are used for database management..........3
Types of relational database...................................................................................................7
Types of relational keys......................................................................................................................8
Types of integrity constraints..................................................................................................9
Types of Entity Relationships...................................................................................................9
Problems with the zoo data spreadsheet...............................................................................10
Relational Database Management Systems..........................................................................11
Normalization.......................................................................................................................12
First normal form, Second normal form, Third normal form...................................................13
ERD Diagram.........................................................................................................................16
A description of the on ERD Diagram.....................................................................................17
Importing data from an external source as well as Creating, populating and building a
relationship database for Emirates Zoo.................................................................................17
Creating Forms to ensure validity and integrity.....................................................................23
Establishing Queries using tables and criteria........................................................................26
Using database features and functions to manipulate data...................................................31
Reports..................................................................................................................................33
Testing the correctness, functionality and acceptance...........................................................36
References.............................................................................................................................46
,Introduction
My name is David, I am an IT advisor and was asked to work with Emirates Zoo to build an
information system for management. I was requested to build Emirates Zoo's relational
database. In the database, records of animals and their keepers will be kept. The zoo takes care
of endangered species from all over the globe. The zoo owner is not familiar with the relational
databases or even how they might be used for the zoo's knowledge management. They would
like me to generate a report that reviews the shape, including normalization, of a relational
database management system. I must clarify how the properties of a relational database are
used for handling databases.
, Explain how the features of a relational database are
used for database management
What is a database, a database is an organized collection of structured information, or data,
usually stored electronically in a computer system. A database most of the time is controlled by
a database management system (DBMS). Most databases are structured query language (SQL)
for writing and querying data.
Standard relational databases let users manage predefined data relationships across multiple
databases. Popular examples of relational databases are: Microsoft SQL Server, My SQL, IBM
DB2 and Oracle Database.
SYSTEMS TO MANAGE
INFORMATION
David Ivan Lemke
MARCH 31, 2022
UKCBC
Level 3 IT
,Table of Contents
Introduction............................................................................................................................2
Explain how the features of a relational database are used for database management..........3
Types of relational database...................................................................................................7
Types of relational keys......................................................................................................................8
Types of integrity constraints..................................................................................................9
Types of Entity Relationships...................................................................................................9
Problems with the zoo data spreadsheet...............................................................................10
Relational Database Management Systems..........................................................................11
Normalization.......................................................................................................................12
First normal form, Second normal form, Third normal form...................................................13
ERD Diagram.........................................................................................................................16
A description of the on ERD Diagram.....................................................................................17
Importing data from an external source as well as Creating, populating and building a
relationship database for Emirates Zoo.................................................................................17
Creating Forms to ensure validity and integrity.....................................................................23
Establishing Queries using tables and criteria........................................................................26
Using database features and functions to manipulate data...................................................31
Reports..................................................................................................................................33
Testing the correctness, functionality and acceptance...........................................................36
References.............................................................................................................................46
,Introduction
My name is David, I am an IT advisor and was asked to work with Emirates Zoo to build an
information system for management. I was requested to build Emirates Zoo's relational
database. In the database, records of animals and their keepers will be kept. The zoo takes care
of endangered species from all over the globe. The zoo owner is not familiar with the relational
databases or even how they might be used for the zoo's knowledge management. They would
like me to generate a report that reviews the shape, including normalization, of a relational
database management system. I must clarify how the properties of a relational database are
used for handling databases.
, Explain how the features of a relational database are
used for database management
What is a database, a database is an organized collection of structured information, or data,
usually stored electronically in a computer system. A database most of the time is controlled by
a database management system (DBMS). Most databases are structured query language (SQL)
for writing and querying data.
Standard relational databases let users manage predefined data relationships across multiple
databases. Popular examples of relational databases are: Microsoft SQL Server, My SQL, IBM
DB2 and Oracle Database.
