JasonParkNormalization

Korth f 0072958863 mysql mysql computers computers

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 072958863 MySQL, MySQL, Computers Computers 1168 McGraw-Hill Operating Operating System Concepts Concepts Abraham Abraham Silberschatz Silberschatz Henry Henry F. Korth F. 0471694665 Computers 944 McGraw-Hill Table 1 problems Table This table is not very efficient with storage. This This design does not protect data integrity. Third, Third, this table does not scale well. First Normal Form First In In our Table 1, we have two violations of First Normal Form: First, we have more than one author field, First, Second, our subject field contains more Second, than one piece of information. With more than one value in a single field, it would be very difficult to search for all books on a given subject. First Normal Table First Table 2 Title Author ISBN Subject Pages Publisher Database System Database Concepts Concepts Abraham Abraham Silberschatz Silberschatz 0072958863 MySQL 1168 McGraw-Hill Database System Database Concepts Concepts Henry F. Korth 0072958863 Computers 1168 McGraw-Hill Operating System Operating Concepts Concepts Henry F. Korth 0471694665 Computers 944 McGraw-Hill Operating System Operating Concepts Concepts Abraham Abraham Silberschatz Silberschatz Computers 944 McGraw-Hill 0471694665 We We now have two rows for a single book. Additionally, we would be violating the Second Normal Form… Second A better solution to our problem would be better to separate the data into separate tablesan Author table and a Subject table to store our information, removing that information from the Book table: Subj e c t Ta bl e Subject_ID Subject_ID Subject 1 MySQL 2 Computers Aut hor Ta bl e Author_ID 1 Silberschatz Abraham 2 Book Ta bl e Last Name Korth ISBN Title Pages Publisher 0072958863 Database System Database Concepts Concepts 1168 McGraw-Hill 0471694665 Operating System Operating Concepts Concepts 944 McGraw-Hill First Name Henry Each Each table has a...
View Full Document

Ask a homework question - tutors are online