c) Table 1, 2 and 3 show the data in a local IT learning academy that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
c) Table 1, 2 and 3 show the data in a local IT learning academy that is famous for various computer learning courses. Because of its popularity, there are increasing number of students enrol in the academy. Since then, the academy needs an efficient automated data storage, hence you are required to determine relational keys to ensure each row in the table is uniquely identifiable. Table 1: STUDENT table STUDENT_IC STUDENT_ID FIRST_NAME LAST_NAME EMAIL COURSE_ID 80193939979 202587788 40122566748 202575526 20164723670 202552244 Ahmad Ali AA@gmail.com 40 Haqiem Wany Rosly haqiem@gmail.com 40 Hazwan wany@gmail.com 50 10108990074 202536987 Haliza Husni Ha@gmail.com 50 80116756736 202512369 90137476323 202533969 50143670971 202574563 Heechul Kim James Reece heechul@gmail.com 40 james@gmail.com 20 Canos Sergi Ola21@gmail.com 20 20 Table 2: COURSE table COURSE_ID 10 20 30 40 50 60 COURSE_NAME Networking Software Developer Web Designer Database Developer Data Analyst IT Professional Table 3: STAFF table STAFF_ID STAFF_NAME COURSE ID 101 Ronaldo 10 102 Vardy 30 103 Toney 60 104 Jimenez 20 105 106 Kane Lukaku 40 50 i) Identify THREE (3) possible superkeys, TWO (2) candidate keys and primary key(s) for the STUDENT table. Justify your answer. (6 marks) ii)Do the tables display both entity integrity and referential integrity? Answer YES or NO, and then explain your answer for each table. (6 marks) c) Table 1, 2 and 3 show the data in a local IT learning academy that is famous for various computer learning courses. Because of its popularity, there are increasing number of students enrol in the academy. Since then, the academy needs an efficient automated data storage, hence you are required to determine relational keys to ensure each row in the table is uniquely identifiable. Table 1: STUDENT table STUDENT_IC STUDENT_ID FIRST_NAME LAST_NAME EMAIL COURSE_ID 80193939979 202587788 40122566748 202575526 20164723670 202552244 Ahmad Ali AA@gmail.com 40 Haqiem Wany Rosly haqiem@gmail.com 40 Hazwan wany@gmail.com 50 10108990074 202536987 Haliza Husni Ha@gmail.com 50 80116756736 202512369 90137476323 202533969 50143670971 202574563 Heechul Kim James Reece heechul@gmail.com 40 james@gmail.com 20 Canos Sergi Ola21@gmail.com 20 20 Table 2: COURSE table COURSE_ID 10 20 30 40 50 60 COURSE_NAME Networking Software Developer Web Designer Database Developer Data Analyst IT Professional Table 3: STAFF table STAFF_ID STAFF_NAME COURSE ID 101 Ronaldo 10 102 Vardy 30 103 Toney 60 104 Jimenez 20 105 106 Kane Lukaku 40 50 i) Identify THREE (3) possible superkeys, TWO (2) candidate keys and primary key(s) for the STUDENT table. Justify your answer. (6 marks) ii)Do the tables display both entity integrity and referential integrity? Answer YES or NO, and then explain your answer for each table. (6 marks)
Expert Answer:
Related Book For
Understanding Business Statistics
ISBN: 978-1118145258
1st edition
Authors: Stacey Jones, Tim Bergquist, Ned Freed
Posted Date:
Students also viewed these databases questions
-
Technique 1: Compression The first technique we will cover is compressing the data. Compression here doesn't mean putting the data in a ZIP file; it instead means storing the data in the memory in a...
-
Calculate in Excel: You are responsible for a portfolio of just two bonds: Bond A is an asset with a face value of $40 million, a price of 102.4, a coupon rate of 4.25%, and exactly 5 years until...
-
In Problems 1316, find each sum. 10 (-2)* k=1
-
Reconsider the axial stiffness data given in Exercise 8. ANOVA output from Minitab follows: Pooled StDev = 32.39. Tukey's pair-wise comparisons Family error rate = 0.0500 Individual error rate =...
-
The lower bound on a non-degenerate American-style put (that is, a put where there is still some uncertainty about whether S T > X or not) is: Assume that ST = 0 and rtT = 0. Common sense says that...
-
Explain the overall patterns of production strategies and their relationship to the environment.
-
(10%) Based on the following production and sales data of Shingle Co. for March of the current year, prepare (a) A sales budget (b) A productionbudget. Estimated inventory, March 1 Desired inventory,...
-
Zachary Corporation reported the following operating results for two consecutive years: Required a. Compute the percentage changes in Zachary Corporation's income statement components between the two...
-
Muscle Pro is a (fictional) public company engaged in selling protein powders and other performance-enhancing supplements. In 20x2, Muscle Pro was sued by a supplier alleging that Muscle Pro did not...
-
Suppose your roomate\'s alarm clock rings too loudly for you to enjoy. Its intensity level at 2 m away of 7 5 dB . How far must you be from this small device to reduce the intensity level to a more...
-
When a person sweats, the water evaporating from the skin undergoes a transition from liquid to vapor. How does this help in regulating body temperature?
-
1. Explain the stages of the consumer buying behavior. Illustrate your answer with a recent personal experience. 2. Explain the meaning of value and highlight the differences between utilitarian...
-
Researchers test canine locomotion by measuring the ground reaction force ( the vector sum of the normal force and the propulsion force ) as dogs push down and backward with both rear legs. In one...
-
Greg Brady formed Johnny Bravo, Inc. (JBI) on January 1, 20x1 by contributing $100,000 in exchange for 100% of JBI stock. JBI immediately (and properly) elected S corporation status. During 20x1, JBI...
-
Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 220 units at $44 per unit. During the year, Cortez made two batch purchases of this chair. The...
-
A. Nominal GDP in 1970 was $1035.6 billion, and in 1980 real GDP was $4609.6 billion, while nominal GDP was $2784.2 billion. The GDP price index was 30.6 for 1970, where 1992 was the base year....
-
What is a content filter? Where is it placed in the network to gain the best result for the organization?
-
In her 2011 book, author and video game designer Jane McGonigal reports, The average young person racks up 10,000 hours of video gaming by the age of 21. Thats almost exactly as much time as they...
-
Below is a relative frequency table showing American household incomes as reported in the 2000 Census? *To simplify your calculations, assume the last income class is $200,000 to $300,000. Notice...
-
To test the cleaning power of two different laundry detergents, ADG Labs randomly chooses five different fabric swatches and soils each one uniformly. Each swatch is cut in half. For each pair of...
-
A population has mean = 25 and standard deviation = 4. a. Find the z-score for a population value of 16. b. Find the z-score for a population value of 31. c. What number has a z-score of 2.5?
-
For the data set 37 82 20 25 31 10 41 44 4 36 68 a. Find the first and third quartiles. b. Find the IQR. c. Find the upper and lower outlier boundaries. d. List all the values, if any, that are...
-
A sociologist samples five families in a certain town and records their annual income. The incomes are $34,000, $57,000, $13,000, $1,200,000, and $62,000. In Exercises 19 and 20, identify the...
Study smarter with the SolutionInn App