Normalization: The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables. If the modifications, deletion or updates occur in one table, the other tables in database get updated by just propagating it. In a relational database, the tables with no redundant data and less null values are considered as efficient table. This is because, having redundant data and more null values increases the storage space and wastage of memory is imminent. Null values cause a problem for data integrity and produces more error in the database. If the wasted storage space and null values which cause data integrity hazards are minimized, a highly optimized relational database can be designed. The project team should consider using normalization when designing the database, which is the best source to optimize data storage efficiently; this is because, it reduces the data storage space and provides data integrity. There are three types of normal forms. First normal form (1NF) Second normal form (2NF) Third normal form (3NF)

Question

Want to see the full answer?

Answer 1

Question

Chapter 6, Problem 2RQ

Program Plan Intro

Normalization:

The process used to minimize data redundancy and dependency in a relational database is known as normalization.

The database table is divided into two or more tables and defines the relationship between those tables.

If the modifications, deletion or updates occur in one table, the other tables in database get updated by just propagating it.

In a relational database, the tables with no redundant data and less null values are considered as efficient table.

This is because, having redundant data and more null values increases the storage space and wastage of memory is imminent.

Null values cause a problem for data integrity and produces more error in the database.

If the wasted storage space and null values which cause data integrity hazards are minimized, a highly optimized relational database can be designed.

The project team should consider using normalization when designing the database, which is the best source to optimize data storage efficiently; this is because, it reduces the data storage space and provides data integrity.

There are three types of normal forms.

First normal form (1NF)

Second normal form (2NF)

Third normal form (3NF)

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

• Solve the problem (pls refer to the inserted image)

Write .php file that saves car booking and displays feedback. There are 2 buttons, which are <Book it> <Select a date>. <Select a date> button gets an input from the user, start date and an end date. Book it button can be pressed only if the start date and ending date are chosen by the user. If successful, it books cars for specific dates, with bookings saved. Booking should be in the .json file which contains all the bookings, and have the following information: Start Date. End Date. User Email. Car ID. If the car is already booked for the selected period, a failure message should be displayed, along with a button to return to the homepage. In the booking.json file, if the Car ID and start date and end date matches, it fails Use AJAX: Save bookings and display feedback without page refresh, using a custom modal (not alert).

Write .php file with the html that saves car booking and displays feedback. Booking should be in the .json file which contains all the bookings, and have the following information: Start Date. End Date. User Email. Car ID. There are 2 buttons, which are <Book it> <Select a date> Book it button can be pressed only if the start date and ending date are chosen by the user. If successful, book cars for specific dates, with bookings saved. If the car is already booked for the selected period, a failure message should be displayed, along with a button to return to the homepage. Use AJAX: Save bookings and display feedback without page refresh, using a custom modal (not alert). And then add an additional feature that only free dates are selectable (e.g., calendar view).