Question: The Midtown Ladies Auxiliary is sponsoring a scholarship for local high school students. They have constructed a table with the structure tblScholarshipApplicants(appId, lastName, hsAttended, hsAddress,

The Midtown Ladies Auxiliary is sponsoring a scholarship for local high school students. They have constructed a table with the structure tblScholarshipApplicants(appId, lastName, hsAttended, hsAddress, gpa, honors, clubsActivities). The hsAttended and hsAddress attributes represent the high school attended and its street address, respectively. The gpa attribute is a grade point average. The honors attribute holds awards received, and the clubsActivities attribute holds the names of clubs and activities in which the student participated. If necessary, redesign the table so it satisfies 1NF, 2NF, and 3NF.

appId lastName hsAttended hsAddress gpa 1 Wong Central 1500 Main 3.8 2

appId lastName hsAttended hsAddress gpa 1 Wong Central 1500 Main 3.8 2 3 4 5 Jefferson Central Mitchell Highland O'Malley St. Joseph Abel Central 1500 Main 4.0 Valedictorian 200 Airport honors Citizenship award Future teachers Class officer Model airplane Soccer MVP Newspaper Pep Yearbook Homecoming court Football MVP Pep 3.6 Citizenship award Class officer clubsActivities Homecoming court Future teachers Pep Chess 1500 Main 3.7 Citizenship award Yearbook Class officer X 300 Fourth 4.0 Valedictorian

Step by Step Solution

★★★★★

3.32 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To redesign the given tblScholarshipApplicants table so that it satisfies the 1st 2nd and 3rd Normal Forms 1NF 2NF and 3NF we first need to understand what each normal form requires 1st Normal Form 1N... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Logic & Design Comprehensive Questions!

Futures and Options as Hedging Alternatives Companies seeking to hedge future purchases or revenue flows can often choose between futures contracts and option contracts. Sami Corp. projects...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Power Failure Snarls Northeast; 800,000 Are Caught in Subways Here; Autos Tied Up; City Gropes In Dark Snarl at Rush Hour Spreads Into 9 States 10,000 in the National Guard and 5,000 Off-Duty...

Solve the statistics below How many chords can be drawn through 21 points on a circle? 4. How many triangles can be formed by joining the vertices of a hexagon? 5. Out of 7 consonants and 4 vowels,...

Holly Farm lnn =GEBF- 4875 il. Holly Avenue Chicago, lL 50660-4875 (3 r2) s55-0203 300 N. Brook Glen Road Northbrook, IL 60062-0300 March 2, 20-- March Mr. Glen Norris. vice Nrar l. 20- A'20-' 20'Mar...

Please Follow the Instructions Subject English 103 Com/Critical Thinking 1. Analyze: In at least words , post a response to the assigned reading by analyzing the text (this is a close reading to find...

Somewhere in the range of 1930 and 1950, female workforce support expanded basically in view of the expanded interest for office laborers, ladies' investment in the secondary school development, and...

Please write 5 conclusions and 5 recommendations on what google can do to expand business into India based on the given data BELOW and write the paragraph connecting the two sections, thank you. Must...

Why does an otherwise competitive market with a negative externality produce more output than would be economically efficient?

20% of Amazon packages are damaged. In an effort to lower this percentage, the new packaging material is introduced. To test whether the new packaging material is successful, a random sample of 300...

What is Amazon's outlook for 3 0 revenue and operating income? 3 0 revenue growth is expected to be around 1 5 % with an operating income of $ 4 - $ 6 Billion. 3 0 revenue growth is projected at 9 -...

5. Every economy faces four fundamental questions:

Write an interactive version of the InchesToFeet class that accepts the inches value from a user. Save the class as InchesToFeetInteractive.java.

Write a program that declares variables to hold your three initials. Display the three initials with a period following each one, as in J.M.F. Save the program as Initials.java.

Meadowdale Dairy Farm sells organic brown eggs to local customers. It charges $3.25 for a dozen eggs, or 45 cents for individual eggs that are not part of a dozen. Write a program that prompts a user...

Consider the single - period market model M = ( B , S 1 , S 2 , S 3 ) with four states of nature = { 1 , 2 , 3 , 4 } . Let the interest rate be r = 1 9 . Stock prices at time t = 0 are given by S 0 1...

Torch Industries can issue perpetual preferred stock at a price of $65.50 a share. The stock would pay a constant annual dividend of $4.50 a share. What is the company's cost of preferred stock, r p...

You are a bond trader for Renaissance Technologies, an active bond fixed-income hedge fund based in New York. You are considering an 8% coupon bond selling for $953.10 with three years until maturity...