DATA & KNOWLEDGE MANAGEMENT

Running head: DATA & KNOWLEDGE MANAGEMENT
DATA & KNOWLEDGE MANAGEMENT
Name of the Student
Name of the University
Author Note

DATA & KNOWLEDGE MANAGEMENT
1
Table of Contents
An analysis of the data security and data management...................................................................2
ERD.................................................................................................................................................2
Normalization..................................................................................................................................4
First Order Normalization............................................................................................................4
Second Order Normalization.......................................................................................................4
Third Order Normalization..........................................................................................................5
Database Schema.............................................................................................................................5
Data Dictionary................................................................................................................................6
An evaluation & Implementation of the relational database...........................................................8
Creation........................................................................................................................................9
Constraints.................................................................................................................................11
Population..................................................................................................................................11
Queries.......................................................................................................................................13
Rationale for the use of the relational model.................................................................................15
References......................................................................................................................................16

DATA & KNOWLEDGE MANAGEMENT
2
An analysis of the data security and data management
Data security and management, both are the main aspects of using relational database
management system (RDBMS). The data security can be achieved by maintain the data
consistency, integrity and quality (Liu et al. 2018). The data quality can be achieved by using
constraints in a database along with the integrity and consistency. On other hand, the
management of the data is also achieved during the design process of the database design. For
data security and management several designing processes are utilized, such as Entity
relationship diagram modelling, normalization, and data dictionary which stores the Meta data of
the database (Jukic, Vrbsky and Nestorov 2014).
ERD
In a Relational Database Management System, the real world objects are identified as
Entities. These Entity sets stored in a database keeps the information. Attributes are used for
keeping the information for an Entities (Rossi 2014). Before implementing the physical database
system, system analysis and design is done by developing Entity relationship Diagram (ERD).
The identification of the Entities and their attributes are done on the basis of the business process
of a company (Weske 2019). The ERD collects these entities and represent the attributes and
relations between the entities. Here the ERD of university is provided in figure 1.

DATA & KNOWLEDGE MANAGEMENT
3
Figure 1: Entity Relationship Diagram of University
Source: created by author