Question

2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1 Places 1 Course Name IT101 1 2009-1 110I Programing IT1e1 I 2009-2 11e0 I Programming IT102 I 2009-11200 1 Databases IT102 I 2010-1 115I Databases IT103 2009-2 1120 I Web Design A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 3) Consider the following: Primary Key ISBN ISBN Title Publisher Address A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 4) Consider the following: Primary Key EmpNum EmpNum 123 679 EmpPhoneEmp 233-9876 Degrees 233-1231 BA, BSe, PhD 233-1231 BSc, MSc Normal Form Violation: A. B. Put into Sentence Structure: C. Normalized

Answer 1

2)OPTION A -Normal form violation.

Because there given the primary key as (CourseID , SemesterID) which means both will find the data from the database table but here in the above given case it is voilating the "SECOND NORMAL FORM" because the the coloumn COURSENAME is not depending on the entitre primary key , but it is depending on the part of the primary key which was "COURSEID".

So which is a partial dependency ..which is violating the 2nd NORMAL FORM.

3)OPTION B

Here given -

ISBN TITLE PUBLISHER ADDRESS

where ISBN is the primary key which helps to find the remaining data from other coloumns uniquley ..so it is in the form of sentence structure ..

4)There are actually two possibilities of outcomes for this question

CASE 1: OPTION A

Because as we know that 1st Normal form states that every cell in the table sholud be filled and no redundancy shold be there ..So since nothing was there in the EMPDEGREES column for the EMPNO-123. So it is violating the 1st normal form..because at least we sholud enter the value as "NULL" instead leaving it empty because sometimes it may leads to huge mess..

CASE2: OPTION C

So if take that empty cell as NULL value which was written in that..So in that case the was in normalized manner because for every value from the table can be taken and gathered by the primary key uniquly which was the EMPNUM..