Consider the schemas for the table people, and the tables students and teachers, which were created under
Question:
Consider the schemas for the table people, and the table’s students and teachers, which were created under people, in Section 9.3.Give a relational schema in third normal form that represents the same information. Recall the constraints on subtables, and give all constraints that must be imposed on the relational schema so that every database instance of the relational schema can also be represented by an instance of the schema with inheritance.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 58% (12 reviews)
A corresponding relational schema in third normal form is ...View the full answer
Answered By
Aysha Ali
my name is ayesha ali. i have done my matriculation in science topics with a+ . then i got admission in the field of computer science and technology in punjab college, lahore. i have passed my final examination of college with a+ also. after that, i got admission in the biggest university of pakistan which is university of the punjab. i am studying business and information technology in my university. i always stand first in my class. i am very brilliant client. my experts always appreciate my work. my projects are very popular in my university because i always complete my work with extreme devotion. i have a great knowledge about all major science topics. science topics always remain my favorite topics. i am also a home expert. i teach many clients at my home ranging from pre-school level to university level. my clients always show excellent result. i am expert in writing essays, reports, speeches, researches and all type of projects. i also have a vast knowledge about business, marketing, cost accounting and finance. i am also expert in making presentations on powerpoint and microsoft word. if you need any sort of help in any topic, please dont hesitate to consult with me. i will provide you the best work at a very reasonable price. i am quality oriented and i have 5 year experience in the following field.
matriculation in science topics; inter in computer science; bachelors in business and information technology
_embed src=http://www.clocklink.com/clocks/0018-orange.swf?timezone=usa_albany& width=200 height=200 wmode=transparent type=application/x-shockwave-flash_
4.40+
11+ Reviews
14+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer Sciences questions
-
Consider as shown below, and suppose that authors could also appear as top level elements. What change would have to be done to the relational schema? similar PCDATA declarations for year,...
-
Consider the AIRLINE relational database schema shown in Figure 3.8, which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or...
-
Consider a relational schema with three relation schemas: DRIVER (Dr_license_no, Dr_name, Dr_city, Dr_state), TICKET_TYPE (Ttp_offense, Ttp_fine) and TICKET (Tic_ticket_no, Tic_ticket_date,...
-
When completed submit your assignment to the appropriate area. Company A, an American company, owns Company B, a Canadian subsidiary. Company A borrowed 1,000,000 Canadian dollars as a hedge on its...
-
The manager of the main laboratory facility at Rosedale Health Center (from E6-50B) collects seven additional months of data after obtaining the regression results in the prior period. The number of...
-
Describe wireless financial services.
-
The system resistance for a pipeline is given by \(\Delta p_{\text {sys }}=2.0 Q^{2}\), where \(\Delta p_{\text {sys }}\) is the pressure rise required of a pump to deliver the flow rate \(Q\)...
-
Jose Corporation has $4,000,000 of 9 percent, 25-year bonds dated March 1, 2010, with interest payable on February 28 and August 31. The companys fiscal year end in February 28. It uses the effective...
-
(a) Apply your linear regression model using gradient descent to find the best fit of the data given by: x = np.array([ 0., 1.66666667, 3.33333333, 5.0, 6.66666667, 8.33333333, 10.0, 11.66666667,...
-
On November 1, 2014, the following were the account balances of Rijo Equipment Repair. During November, the following summary transactions were completed. Nov. 8 Paid $1,220 for salaries due...
-
Redesign the database of Exercise 9.1 into first normal form and fourth normal form. List any functional or multivalued dependencies that you assume. Also list all referential-integrity constraints...
-
A car-rental company maintains a vehicle database for all vehicles in its current fleet. For all vehicles, it includes the vehicle identification number, license number, manufacturer, model, date of...
-
You correctly defined and introduced the Scope Bank to your client, who initially agreed to use it. However, the client seems to have forgotten their agreement. The Scope Bank needs a deposit in...
-
One of the important difference between a Windows OS and Linux OS is how Linux treats the file structure and hardware devices.Explain how Linux treats hardware devices in the OS. Or Discussion...
-
1. Go to the WTO's website at www.wto.org/ and identify four goods or services that have been the sources of trade disputes between countries in the last three years.
-
Discuss how Linux has long been known as an excellentserverplatform and there are several distributions of Linux that come packaged as a desktop client operating system to run general-purpose office...
-
Write an application that adds the following time stamp in the selected data structure. Event 1 occurs at 1 2 : 0 0 : 5 4 Event 2 occurs at 1 0 : 4 0 : 5 4 Event 3 occurs at 1 1 : 3 0 : 4 5 Event 4...
-
What is an insurance premium? Why do premiums vary? briefly explain the term insurance premim.
-
Consider a weird derivative with the payoff \(W_{T}\) depicted in Fig. 2.5, depending on the price \(S_{T}\) of a certain underlying asset at time \(t=T\). The breakpoint prices, \(K_{1}...
-
Assume today is the 21st of February. Using the information below, FT Extract, answer the following questions (parts i and ii). You work for a US company that is due to receive 250 million in June...
-
In these images, a blue circle represents an atom of one type of element, and a red square represents an atom of a second type of element. Which image is a pure substance? (a) (b) (c) None of the...
-
Why is it easier for a distributed file system such as GFS or HDFS to support replication than it is for a key-value store?
-
What is the motivation for storing related records together in a key-value store? Explain the idea using the notion of an entity group.
-
Partitioning and replication. a. Explain why range-partitioning gives better control on tablet sizes than hash partitioning. List an analogy between this case and the case of B+-tree indices versus...
-
Water flows through a pipe section that tapers from an internal diameter of 200 mm down to 100 mm over a distance of 1 m. Determine the pressure drop over the section for a flow of 0.06 m3s-1. The...
-
Calculate the binding energy per nucleon for Be, 59 Co, 208 pb, and 195 pt. (For the atomic masses, see this table. Enter your answers to at least two decimal places.) (a) Be MeV/nucleon 59 Co...
-
A.Final ProjectTeamProjectCustom Schema: 200 points Extra Credit Group of 3 people : Designer and Developer ( ERD, tables, data ) Team Leader/Power User ( Business Questions/Queries, Real Life...
Study smarter with the SolutionInn App