logo

Database Design Assignment Normalization

8 Pages1134 Words77 Views
   

Added on  2020-04-07

Database Design Assignment Normalization

   Added on 2020-04-07

ShareRelated Documents
Running head: DATABASE DESIGNDatabase DesignName of the StudentName of the University
Database Design Assignment Normalization_1
DATABASE DESIGN1Table of Contents1. Answer to Question 1:.................................................................................................................22. Answer to Question 2:.................................................................................................................33. Answer to Question 3:.................................................................................................................43. a. Anomalies Description:...........................................................................................................53. b. Solution to Prevent Anomalies:...............................................................................................5Bibliography:...................................................................................................................................7
Database Design Assignment Normalization_2
DATABASE DESIGN21. Answer to Question 1:The database normalization method or data normalization approach is the process oforganizing the attributes of an entity regarding a transactional databases and data warehouses. Ifa successful database design needs to be normalized. If the database system is not properlynormalized, then the database will be slow, ineffective and improper. These kinds of databaseexperiences data redundancy and anomalies. 1)Each phase of normalization process take out a specific kind of undesirable reliance 2)It features imperatives and reliance in the information and consequently help the understanding the idea of the information 3)Normalization characterizes productive information structures 4)Normalization controls information excess to lessen capacity necessity and standard support 5)Normalization dispense with pointless reliance relationship inside a database document6)Normalization give one of a kind distinguishing proof to records in a database 7)Normalization licenses basic information recovery because of reports and questions 8)Standardized information structures are utilized for record and database outline 9)The third normalization shape delivers very much planned database which gives a higher level of independency
Database Design Assignment Normalization_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design And Development - Assignment
|9
|884
|27

Database Implementation and Research Activity: SQL Queries, NoSQL Features | SEO
|7
|1136
|75

Report on Relational Database Principles and Designing Of SQL
|24
|2063
|47

SQLite Assignment
|9
|851
|184

Database System and Design
|12
|800
|81

Database Concepts - Study Material and Solved Assignments
|9
|730
|289