Question: 3. Given the following table, create a relational database in MS Access through normalization. Ensure that each table is in at least 3NF. You

3. Given the following table, create a relational database in MS Access through normalization. Ensure that each table is in at least 3NF. You may include additional attributes as necessary (30 points). DEPT NAME STU NUM STU LNAME STU MAJOR 211343 Stephanos 200128 Smith 199876 Jones 198648 Ortiz 223458 McKulski Accounting Accounting Marketing Marketing Statistics DEPT CODE ACCT Accounting ACCT Accounting MKTG Marketing MKTG Marketing MATH Mathematics DEPT COLLEGE ADVISOR ADVISOR ADVISOR ADVISORSTU GPA HOUR STU_CLASS PHONE NAME LNAME OFFICE BLDG PHONE 4356 4356 4378 4378 3420 Business Admin Business Admin Business Admin Business Admin Arts & Sciences Grastrand 201 Grastrand T201 Geetry Tibery Chen T228 T356 J331 Torre Building Torre Building Torre Building Torre Building Jones Building 2115 2115 2123 2150 3209 3.87 2.78 2.31 3.45 3.58 75 Junior 45 Sophomore 117 Senior 113 Senior 87 Junior

Step by Step Solution

★★★★★

3.41 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The image shows a spreadsheet with data on students departments and advisors To create a relational database in MS Access through normalization ensuri... 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 Questions!

How does Max Weber's theory of rationalization elucidate the processes of bureaucratization and the disenchantment of the modern world, particularly within the realms of economy and administration ?

For the following data: Fixed cost = 120,000 $ Variable cost per unit = 350 $ Selling price per unit=550 $ a. Find number of unit (Units of Production) to verify BEP. Find BEP. b.Find number of unit...

Using the STUDENT table structure shown in Table P6.4, do the following: a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive...

Student-Instructor-Parent Database You are asked by a local high school administrator to create a student-instructor-parent (SIP) database for their after-school program. Follow the steps to create...

You are asked by a local high school administrator to create a student-instructor-parent (SIP) database for their after-school program. Follow the steps to create SIP database 1) Create a relational...

Instructions. HW 3 Attached Files: 1S_3063_HW3.xlsx (16.482 KB) HW 3 allows you to implement the data models we learned so far to an actual database. Please review the two lectures for Chapter 4...

Please Build Database and Static Queries. MY LAST NAME STARTS WITH R, SO MY INDUSTRY IS APPLIANCES. Two of the images are the instruction for this project and one image is the assignment 2 that I...

Uploaded our Context Diagram, Was hoping someone could check for the validity of it according to the assignment. Bank Merc hand i Consignor se/ G oods Fees Cont racts Unso ld M ercha ndise / goo ds...

HW 3 allows you to implement the data models we learned so far to an actual database. Please review the two lectures for Chapter 4 before starting this assignment. This assignment requires you to...

El Paso Coffee Roasters is a family-owned chain of coffee roasters. They have expanded from their humble beginnings in El Paso, to a $30,000,000 business with stores in 44 cities throughout the...

A 2 B The inlet to the CSTR has a variable volumetric flow rate ( L / min ) , q ( t ) , with a constant concentration of species A ( m o l L ) , C A . The stream exiting the reactor has a volumetric...

Blossom Inc. manufactures a single product in a continuous processing environment. All materials are added at the beginning of the process, and conversion costs are incurred uniformly throughout the...

The Windber Company is in its planning stage for next year. Windber expects sales to dip in Quarter 2 and is creating a production budget to determine if it needs to lay off employees. Windber knows...

Filtration , choose the incorrect answer depends on hyprostatic pressure depends on oncotic pressure the hydrostatic pressure is more at venous side of capillary the oncotic pressure is caused by...

A pair of StYaight teeth spur geard, having 20 involutek tull depth teerh is to halre tranj mitted Poleer 12 KW at 300 rpun ef the Pinioh. The Speed ratio is 3. Tha allowable static Stresse) for Sear...

A helical cast steel gear with 30 helix angle has to transmit 35 kW at 1500 r.p.m. n A helical cast steel with 30 helia angle has +o tanmiz 35 KW at 1500 Y An. Gear has 24 teeth , 20 full depth. The...

Provide a test (including reagents needed and what to look for if it gives a positive result), and the net ionic equation for the test used, to distinguish between the following compounds. NiCl2 or...

If you try to start writing your first draft without an outline, you force your brain to juggle _______ at the same time. Question 3 options: A) drafting and proofreading B) organizing and composing...

Suppose you were responsible for establishing a training program for users of Hoosier Burgers inventory control system (described in previous chapters). Which forms of training would you use? Why?

Compare Figures 1-2 and 1-10. How does Figure 1-10 illustrate some of the problems of the traditional waterfall approach that are not illustrated in Figure 1-2? How does converting Figure 1-10 into a...

What is e-learning?

A motor cycle manufacturer produces three model: A, B and C, This months master production schedule, divided by 22 work day, has resulted in daily production targets of 54 As, 42 Bs, and 30 Cs, The...

A manager wants to determine the number of kanbans to use in a new process for a part. The process will have a usage rate of 80 pieces of the part per hour. Because the process is new, the manage has...

A JIT/lean system uses kanban cards to authorize production and movement of materials. In one portion of the system, a work centre uses an average of 100 pieces of a part per hour. The manager has...