Question: 1, Normalize the following table 2. Explain what referential integrity is and give an example. 3. Name attributes for a customer table, customer credit card

1, Normalize the following table

2. Explain what referential integrity is and give an example. 3. Name attributes for a customer table, customer credit card table and inventory table. (must be at least five attributes)

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline StuNo & Stu Name & Class No & Class Desc & Inst No & Inst Name & Room \# & Room Desc & Room Time & Day & \begin{tabular}{l} Course \\ Department \end{tabular} \\ \hline 1 & Smith & 101 & Economic & A & Carr & 401 & Loop & 9:00 & M & Business \\ \hline 1 & Smith & 102 & Economics 2 & A & Carr & 401 & Loop & 10:00 & M & Business \\ \hline 1 & Smith & 106 & Math & B & Mell & 401 & Loop & 10:00 & T & Math \\ \hline 2 & Jones & 101 & Economic & A & Carr & 401 & Loop & 9:00 & M & English \\ \hline 2 & Jones & 103 & English & C & Beckfield & 402 & O'Hare & 9:00 & M & Business \\ \hline 3 & Lee & 104 & Shakespere & D & Anderson & 402 & O'Hare & 10:00 & T & English \\ \hline 3 & Lee & 105 & PE & E & Armonda & 402 & O'Hare & 9:00 & W & Physical Ed \\ \hline 3 & Lee & 107 & Economics 3 & A & Carr & 401 & Loop & 9:00 & W & Business \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

Explain what referential integrity is and give an example. 2 Name attributes for a customer table, customer credit card table and inventory table. (must be at least five attributes)

Table 1: CUSTOMER. Problem 1 Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CustomerID LastName First Name City Phone Shire Robert Seattle 20624-2433 Goodyear...

please answer with great detail and explanations ASSIGNMENT 2: GARDEN GLORY PROJECT QUESTIONS (Chapter Two) Submission: A single.doc or .pdf file to Canvas Note: Spelling check in Microsoft Word may...

MusicMash is a startup business specializing in online music sales. After receiving initial funding from investors, the founders of MusicMash are ready to start developing their online business. The...

Your assessment of the strengths and weaknesses of the internal controls (Physical, and IT General Controls) environment as a whole. These information systems (and the tables to which they relate)...

Required Information Problem 4-8 and Problem 4-9 [LO 4-2] [The following information applies to the questions displayed below) Use the Access_Practice accdb database to complete the following tasks...

Can you help me out with questions 10-14 and problem 16. I attached two images because the scenario is on another page . Include InvoiceID, InvoiceDat X d. Calculate total sales for each inventory...

BYGB/ISGB 7973: ASSIGNMENT 2 DATABASE MANAGEMENT SQL Assignment Part I You may want to use the CreateTable_TG.ddl that we used for the TradeGroup an exemplar for this question. This exercise is based...

Mr. and Mrs. Worried, longtime clients, have come to you for help. Their 13-year-old son has recently been expelled from the public junior high school because of severe behavioral problems,...

On January 1, 2015, Harter Company had Accounts Receivable $139,000, Notes Receivable $25,000, and Allowance for Doubtful Accounts $13,200. The note receivable is from Willingham Company. It is a...

Using the instructions in Easton, Wild, Halsey & McAnnally ( EWHM ) Module 1 , Appendix 1 A , obtain the most recent Target 1 0 - K from the U . S . Securities and Exchange Commission ( SEC ) EDGAR...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...