Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this exercise you will: 1.) Run the attached SQL script exampleData.sql in your preferred way (E.g., workbench or from the command line tool in

In this exercise you will: 1.) Run the attached SQL script "exampleData.sql" in your preferred way (E.g., workbench or from the command line tool in a terminal window.) This script creates a database named FN1 and a table named "VoterData", and loads three rows of data into the table. Notice that the data are not stored in First Normal Form because two of the columns: "address" and "email" are used in a way that makes their data nonatomic. A valid address is hierarchical: street number, street name, city/town name, state, zip code, etc. The email field is used to store more than one email address. (If you want to know more about postal addresses read this: https://en.wikipedia.org/wiki/Address) 2.) Watch Caleb Curry's video on First Normal Form and understand what this means and how he redesigns his database. Notice that the database I gave you is similar to his. 3.) Redesign the provided example database so that the email information is in first normal form. This means that you will create a new table called "EmailAddresses" that is specialized for storing email address information, and, it has a foreign key relationship with the VoterData table, etc. When you finish save your work as an SQL file

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

Next Generation Databases NoSQLand Big Data

Authors: Guy Harrison

1st Edition

1484213300, 978-1484213308

More Books

Students also viewed these Databases questions

Question

Knowledge of project management (PMI) teachings

Answered: 1 week ago

Question

Explain the function and purpose of the Job Level Table.

Answered: 1 week ago