Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pretend that you have been asked to build a system that tracks student involvement in activities around campus. You have been given a file with

Pretend that you have been asked to build a system that tracks student involvement in activities around campus. You have been given a file with infor-mation that needs to be imported into the system, and the file contains the following fields: Student Social Security number (identifier) Activity 1 code (identifier) Activity 1 description Activity 1 start date Activity 1 years with activity Activity 2 code Activity 2 description Activity 2 start date Activity 3 code Activity 3 description Activity 3 start date Activity 3 years with activity Student last name Student first name Student birthdate Student age Student advisor name Student advisor phone. Normalize the file. Show how the logical data model would change as you move from 1NF to 2NF to 3NF.

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

Progress Monitoring Data Tracking Organizer

Authors: Teacher'S Aid Publications

1st Edition

B0B7QCNRJ1

More Books

Students also viewed these Databases questions

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago