A high school wishes to develop a database to manage the marks for their learners in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A high school wishes to develop a database to manage the marks for their learners in Grade 8 through to Grade 12. Each teacher takes one or more subjects, however, no more than one teacher teaches one subject. Each learner studies six subjects per grade, and has to complete one or two homework assignments for each subject and write a test for every subject. Design a relational database schema for storing the above data in the third normal form. Also indicate the primary and foreign keys. Give the schema using a generic tabular format, i.e. it is not necessary to write SQL code. A high school wishes to develop a database to manage the marks for their learners in Grade 8 through to Grade 12. Each teacher takes one or more subjects, however, no more than one teacher teaches one subject. Each learner studies six subjects per grade, and has to complete one or two homework assignments for each subject and write a test for every subject. Design a relational database schema for storing the above data in the third normal form. Also indicate the primary and foreign keys. Give the schema using a generic tabular format, i.e. it is not necessary to write SQL code.
Expert Answer:
Related Book For
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118155974
6th edition
Authors: Michael H. Granof, Saleha B. Khumawala
Posted Date:
Students also viewed these databases questions
-
Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
In Exercises 7192, find and simplify the difference quotient f(x +h)-f(x) h -, h = 0
-
One property of automobile air bags that contributes to their ability to absorb energy is the permeability (ft3/ft2/ min) of the woven material used to construct the air bags. Understanding how...
-
Yummy Candy Company is considering purchasing a second chocolate dipping machine in order to expand their business. The information Yummy has accumulated regarding the new machine is: Cost of the...
-
Customer relationship management (CRM) and key account management (KAM) are two separate elements of the sales process. Explain how the two might be interrelated.
-
The ledger of Molindo Company has the following work in process account. Production records show that there were 400 units in the beginning inventory, 30% complete, 1,100 units started, and 1,200...
-
Suppose the speed is 1800 rpm and the torque is 20ft-lbs.Determine the horsepower and output watts.
-
Daniel Company uses a periodic inventory system. Data for 2015: beginning merchandise inventory (December 31, 2014), 2,000 units at $38; purchases, 8,000 units at $40; expenses (excluding income...
-
The transactions below pertain to Mavtech's second month (October) of operations. 1. Paid $11,000 to the supplier to complete payment on the furniture and fixtures bought on September 1, 2015 (refer...
-
ABC corp. issues a 7 year $1,000 face value bond that has an annual coupon rate of 8.44% and pays interest semi-annually. Similar bonds are offering a yield to maturity of 12.9%. What should be the...
-
You've just purchased a $1,000 face value bon for $930. It pays semi-annual coupons and has 10 years to maturity and a 7.60% coupon rate. At what price should you be able to sell the bond in 4 years...
-
A firm issues a floater with 100 face value paying LIBOR on the first day of each calendar quarter. The floater will mature on Jan 1, 2040. Assume the yield curve is always flat. The floater was...
-
Calculate the requested measures in parts (A) through (F) for bond X, assuming that it pays interest semiannually: (A) (B) (C) (D) (E) (F) Bond X Coupon 9% Yield to maturity 8% Maturity (years) 5 Par...
-
City Bank in Manhattan has provided you with the follow currency quotes. Bid Ask Euro in $ 1.21 1.35 Pesos in $ $.21 $.22 Euro in pesos 11 12 You have $5,000. a. Is there any arbitrage opportunity...
-
Fill in the blank for each of the following situations. Balance Sheet Beginning Ending Income Statement Cash Inflow (Outflow) Accounts Receivable $2,000 $5,000 Sales on Account, $15,000 Prepaid...
-
PC Contractors, Inc., was an excavating business in Kansas City, Missouri. Union Bank made loans to PC, subject to a perfected security interest in its equipment and other assets, including...
-
The bylaws of the Wells City Downtown Development Authority state that of the seven members of its governing board, two must be members of the Wells City Council, one must be a member of the City...
-
The following information was abstracted from a note, headed Interfund Transactions, to the ï¬nancial statements of Independence, Missouri. Interfund Charges for Support Services Interfund...
-
This problem is based on a recent annual report of the City of Tucson. Dates have been changed. 1. The letter of transmittal from the city's nance director reports that the city's bonds were rated AA...
-
Have you ever been informed of the information flow in your unit or division?
-
If so, did you receive the information in a formal seminar or in an informal manner, oneon-one with another individual? Do you think this was the best way? Why?
-
Do you know about the chart of accounts in your organization as it pertains to information you receive?
Study smarter with the SolutionInn App