Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm having trouble normalizing my entities and making them into 3rd normal form. Can anyone show me how they'd approach this question? The entities must

I'm having trouble normalizing my entities and making them into 3rd normal form. Can anyone show me how they'd approach this question? The entities must be transformed into relations and normalized into 3rd normal form

image text in transcribed

image text in transcribed

Below is my attempt, but it does not seem correct. Again, the instructions say that the entities need to be normalized and in third normal form. Would it be like this first example or the second?

1st:

image text in transcribed

2nd:

image text in transcribed

The project is designing a complete database management system to address a practical database need and implement a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of VCPP University. The initial entities for your model are STUDENT, COURSE, and INSTRUCTOR. In addition to these initial entities, you are provided with several business rules. You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as inaccurate or incomplete work. Your grade represents your pay. Initial Entities. STUDENT (StudentID. StudentName, StudentAddress, StudentPhone, StudentEmail, StudentDOB, StudentMajor, GPA) COURSE (CourseID, CourseName, CreditHours) INSTRUCTOR( InstructorID, InstructorName. InstructorAddress, InstructorPhone, InstructorEmail, Salary) Deliverable 1 Begin with the initial entities for STUDENT, INSTRUCTOR, and COURSE provided above, transform them into RELATIONS, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3rd Normal Form. This is obvious by the many-to-many relationship that would need to exist between INSTRUCTOR and COURSE, COURSE and STUDENT, INSTRUCTOR and STUDENT You are to do the steps necessary to obtain 3rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come with (and their relationships) once you have achieved 3rd Normal Form. Hint: Your answer will be within the Word document you submit as your Project 1 Assignment response along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships). This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships. Primary Key, Foreign Key STUDENT StudentID Student Name StudentLName SStreet# SStreetName Studentzip. SEmail SMajor GPA Studentzip StudentCity StudentState COURSE CourselD CourseName Credit Hours INSTRUCTOR Instructor Instructorid Instructor Name Instructor Name InstructorStreet InstructorStreetName InstructorZIP InstructorEmail InstructorPhone InstructorEmail Salary Instructor ZIP InstructorState InstructorCity STUDENT: StudentID StudentName StudentAddress StudentPhone StudentEmail StudentDOB Student Major GPA COURSE: CourseID CourseName CreditHours INSTRUCTOR: InstructorID InstructorName Instructor Address InstructorPhone Instructor Email Salary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions