Normalization and Database Design

Explain why normalization is important to database design. Describe the fourth normal form (4NF) of normalization. Why is important to denormalize some tables of a database?

Relational Databases

Relational databases are the most common type of databases used today. The main reason for its popularity is the fact that relational database systems allow users to view the database in a logical rather than a physical way. This eliminates the need for users to understand the underlying details of how the data is stored. The relational database uses tables (relations). How are relational databases able to use tables to create relationships? Why do we need a unique identifier in each table? Suppose we are the design the library database at UGBC, how many (main) tables might we need? What are the main tables? How can we set up the relationships among the different tables.

Advantages of using a database.

A database surely has great advantages over a traditional record keeping system. From ease of access to user access control and security to efficient storage and manipulation, a database system is ideal for use by organizations and companies. How can a database management system benefit the UGBC library?

Welcome to the CSI 212 Blog

This blog was created to facilitate discussions among students and teacher on matters and issues arising out of CSI 212 - Database Management, a second year computer science course at the University of Guyana, Berbice Campus. All posts will be monitored. Remember, online involvement constitutes 5% of the course work marks.