• Describe what a relational database is and why relational databases are needed.
Introduction: The knowledge of databases is an essential requirement for any being who has majored in the field of computers and IT. Same criteria is involved for a technologist.
Relational Database:
Relational Database, also known as RDB, is major sub-branch of Database. A relational database, or more commonly known as RDB, is a collection of multiple data sets. Mainly comprising of or, organized by the following:
- Tables,
- Records, and
- Columns.
Description of Relational Databases: Relational Database, establishes a well-defined and a properly structured relation among all the tables present in a database. …show more content…
Moreover, unobstructed access to important data means better information for more effective decision making.
• Describe the process of normalization and why it is needed.
The Normalization Process: The process of Normalization is defined as the method of alleviating the redundancy in data within a database.
It is a technique used while designing or redesigning a DB. Normalization is a method used for analyzing the given data to design a database system. It permits and enables the database designer to understand the data structures existing within an organization. Moreover, this procedure succors, any future changes and enhancements that might, relatively, be made in the system.
Steps of Normalization:
Following are the basic steps that are to be followed while normalizing a database:
1. Selection and conversion of a data source into an un-normalized table, i.e. (UNF)
2. Transforming the un-normalized data into first normal form, i.e. (1NF)
3. Transformation of data, further, from first normal form (1NF) into the second normal form …show more content…
• Contrast and compare logical and physical database design.
Logical data model
Logical data model explains the data in a detailed manner, without regarding to the manner in which the designing is done.
Physical data model
Physical data model explains how the model will be constructed within a database. A physical database model shows all table structures.
Comparing and contrasting the features of a Logical and a Physical database Designs: Logical Database Design Physical Database Design
An important feature of this type of DB Design is that it embraces all entities and the relationships existing among them.
Here, all the attributes for each entity involved are specified. It specifies the primary key for all the entities Here, the Foreign keys are specified. FKs define the relationship between various entities. Normalization occurs at this level. Involves, specifying all the tables and columns.
It involves the feature known as Foreign Key usage, which is used to show the relation between the