Homework2-NormalForms
.pdf
School
Longwood University**We aren't endorsed by this school
Course
CMSC 362
Subject
Biology
Date
Dec 17, 2024
Pages
3
Uploaded by ConstableTeam26556
Homework 2CMSC 362Due: March 23, 2023Name:Do exercises 3.1.3a, 3.2.1, 3.3.1a-c, and 3.3.4, then solve the problem on the back of this worksheet.3.1.3a3.3.1c3.2.1a3.2.1b3.2.1c3.3.43.3.1a3.3.1b
Now, consider the database described below which might be used by a scientific society to organize meetings about topics. The organization is divided into member groups by subject. Memberscan belong to more than one subject group. Each subjectholds meetingsabout topics. Because not everyone fits in a single room, these meetings are divided into sections. Both sectionsmeet on the same day and have the same topics. You may assume that:“Name” is the primary key of the “members” table. “Subject” and “Section number” together make up a primary key for the “sections” table. “Subject” and “Date” together make up the primary key of the “meetings” table. Dates are atomic.The “difficulty of topic” field indicates what at grade level introduction of the topic is appropriate.The “next meeting” is always the same for both sections of a subject. MembersNameDate JoinedInterestsJohn Smith10/20/09Biology, ChemistryJohn Adams05/23/17Chemistry, MathematicsSusan Smith10/20/09Computer Science, Astrology, PhrenologySectionsSubjectSection numberNext MeetingBiology102/27/2014Biology202/27/2014Chemistry102/28/2014Mathematics103/01/2014MeetingsSubjectDateTopicsDifficulty of TopicBiology02/27/2014Fish3Biology03/12/2014Ion channels11Chemistry02/28/2014Ion channels11Chemistry03/01/2014Electrons81. Which columns of which tables violate 1NF?2. Why isn't this database in SECOND normal form (if there is more than one reason, give all of them)?3. Why does the “meetings” table violate third normal form (if there is more than one reason, give all of them)?
4. Normalize the database so that it satisfies 3NF. Give the normalized tables (including their data) below: