Analyze the given database tables I. ANALYSIS. Analyze the given cases and answer the questions 1. Given
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
I. ANALYSIS. Analyze the given cases and answer the questions 1. Given the Un-normalized Student table, analyze by steps the process of converting this table to 1NF and 2NF form with schema for 1NF and 2NF. Student# 123 AdvID 123A AdvName James AdvRoom 555 class 102-8 104-9 124 123B Smith 467 20S-0 102-8 2. The table shown in the figure shows the information regarding the faculty and courses. This table is susceptible to update and deletion anomalies. FacultyID 398 407 427 Faculty Name Dr. Hussain Dr. Ahmed Dr. Zainab Faculty Hire date 10-Feb-2014 12-May-2016 13-Apr-2014 Course code BSBI411 COMP411 BSBI611 a. Evaluate the update and deletion anomalies that maybe present with an example (Marking scheme: 2 marks-1 mark each for the update and deletion anomaly with example) b. Summarize the role of normalization in removing the anomalies in a relation. (Marking scheme: 4 marks: 1 mark for each role identified) I. ANALYSIS. Analyze the given cases and answer the questions 1. Given the Un-normalized Student table, analyze by steps the process of converting this table to 1NF and 2NF form with schema for 1NF and 2NF. Student# 123 AdvID 123A AdvName James AdvRoom 555 class 102-8 104-9 124 123B Smith 467 20S-0 102-8 2. The table shown in the figure shows the information regarding the faculty and courses. This table is susceptible to update and deletion anomalies. FacultyID 398 407 427 Faculty Name Dr. Hussain Dr. Ahmed Dr. Zainab Faculty Hire date 10-Feb-2014 12-May-2016 13-Apr-2014 Course code BSBI411 COMP411 BSBI611 a. Evaluate the update and deletion anomalies that maybe present with an example (Marking scheme: 2 marks-1 mark each for the update and deletion anomaly with example) b. Summarize the role of normalization in removing the anomalies in a relation. (Marking scheme: 4 marks: 1 mark for each role identified)
Expert Answer:
Related Book For
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall
Posted Date:
Students also viewed these databases questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
what ways do calligraphers employ "rhythm and flow" to imbue their compositions with a sense of dynamism and elegance ?
-
At December 31, 2016, Pioneer Corporation reported the stockholders' equity accounts shown here (with dollar amounts in millions, except per-share amounts). Common stock $3.00 par value per share, 22...
-
Laramie Ltd. uses a normal job-order cost system. At the beginning of the month of June, two orders were in process as follows: There was no inventory of finished goods on June 1. During the month of...
-
What are the benefits of supermarkets using customer tracking technology?
-
Hijras are followers of a Hindu goddess, Bahuchara Mata, and the hijra subculture is partly a religious group centered on the worship of this goddess. By dressing as women, and especially through...
-
Refer to Figure and Solved Problem. If inventory consists of 2 units of B, 1 unit of F, and 3 units of G, how many units of G, E, and D must be purchased to produce 5 units of productA? Cu) B13) LT 3...
-
The hip roof shown in the below Figure 2 is constructed of 2x10 rafters spaced 16 inches on center. The hip rafters are 1 -inch-wide by 12-inch-high GLBs. The roof has a slope of 4:12. Prepare a list...
-
Grandfoods, Inc., makes energy supplement bars for use by athletes and others who need an energy boost. One of the critical quality characteristics is the weight of the bars. Too much weight implies...
-
Response, review the initial posts of your peer. How did your answer differ from your peers' answers? What do you suppose is the reason for the difference in answers? What additional items would you...
-
Abar's current ratio is 3.48 debt ratio is 1 time interest earned is 1.81 inventory turnover is 1.50 asset turnover is 1.6 average collection period is 50.5 and net profit margin is 30%. as a loan...
-
1. (50 points) Design the simplest circuit that has four inputs, a, b, c, and d, which produces an output value of 1 whenever three or more of the input variables have the value 1; otherwise, the...
-
Give a clear English description of the language accepted by the following DFA: 2 3 a,b Q. 2 Maximum score 10 Construct a DFA ( a diagram) that accepts ail strings in the alphabet {a,b} of length up...
-
What is strategic procurement? Drawing from your organization or any that you are familiar with, explain how strategic procurement management can contribute to the competitive advantage of an...
-
Sharing economy - who succeeded and who did not: The sharing economy was born out of the concept that multiple individuals can utilize a single commodity rather than privately owned by one entity or...
-
dx partial fractions 3+5 x sin(3x)
-
Discuss the information available from the following techniques in the analysis of inorganic pigments used in antique oil paintings: (i) Powder X-ray diffraction, (ii) Infrared and Raman...
-
What are the three guidelines for designing good screen dialog?
-
List five guidelines for designing a corporate privacy policy for ecommerce applications.
-
Given the following file of renters: a. Show an example of projection. b. Show an example of selection. c. Show two different examples of sorting rows. d. Show an example of calculatingtotals. Record...
-
The inversion point of a gas can be mathematically expressed as (a) \(T_{i}=\frac{2 a b}{R}\) (b) \(T_{i}=\frac{2 b}{R a}\) (c) \(T_{i}=\frac{2 a}{R b}\) (d) None of these.
-
Residual free energy is defined as (a) \(G^{R}=G-G^{\mathrm{ig}}\) (b) \(G^{R}=G^{\mathrm{ig}}-G\) (c) \(G^{R}=G+G^{\mathrm{ig}}\) (d) None of these.
-
Departure functions are useful to calculate the thermodynamic property of real fluids (a) When the \(P-V-T\) data of the substance is unavailable (b) When the \(P-V-T\) data of the substance is...
Study smarter with the SolutionInn App