Figure 9.8 shows an ER schema for a database that may be used to keep track of

Question:

Figure 9.8 shows an ER schema for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema, and specify all primary keys and foreign keys.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Fundamentals of Database Systems

ISBN: 978-0136086208

6th edition

Authors: Ramez Elmasri, Shamkant Navathe

See More Books

Question Posted: Apr 26, 2016 08:17 AM

See More Questions

Design an EER schema for a database application that you are interested in. Specify all constraints that should hold on the database. Make sure that the schema has at least five entity types, four...
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (SSN, From_City, To_City,...
Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT (SSN, Name, Major, Bdate) COURSE (Course#, Quarter,...
An employee received the following benefits: regular compensation income, net of P25,000 SSS, PHIC & HDMF employee share - P850,000; 13th month pay - P120,000; De minimis benefits within their limits...
Compare and contrast at least three work related characteristics of Hispanic and Anglo-American cultures.
The following quote is taken from an article (by L. Bernstein) scrutinizing use of reserves to recognize future costs and losses. The growing use of reserves for future costs and losses impairs the...
Two parallel disks each of radius $R$ are facing each other and separated by a distance $H$. Derive an expression for the view factor between these disks.
Wendy and Frank Cotroni, ages 30 and 35, plan to purchase life insurance. Wendy does not have any coverage, while Frank has a $150 000 policy at work. The Cotronis have two children, ages three and...
A lone wire connects two well-separated conducting spheres. One sphere has a radius of 10.0cm and an electric potential of 250.0V (using a reference of the zero point at infinite distance). The other...
Case Construction Company, a three-year-old business, provides contracting and construction services to a variety of clients. Given that each construction job is different from any other, company...
Try to map the relational schema of Figure 6.14 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database....
Map the BANK ER schema of Exercise 7.23 (shown in Figure 7.21) into a relational schema. Specify all primary keys and foreign keys. Repeat for the AIRLINE schema (Figure 7.20) of Exercise 7.19 and...
An If...Then...Else statement in the btnCalc_Click procedure declares a variable in its false path. Where can the variable be used? a. in the entire Code Editor window b. in the entire btnCalc_Click...
using the classical model closed economy what are the effects on the variables below of a temporary increase in government spending. --- Output --- Real Interest ---Price level --- Wage rate ( real )...
5. An economys AD (Aggregate Demand) function is Y = 1000 2P and AS (Aggregate Supply) function is P = 20 + 0.1Y. Show these two lines in a graph. Label graphs. Find the equilibrium price level (P)...
QUESTION. MSFConsole Samba Watch the Metasploit Framework video, follow along to get connected to metasploitable 2. Submlt a word document with the useridls and passwords of all of the local accounts...
As a criminal justice administrator, discuss what sort of system would you create to objectively measure as well as enforce organizational accountability and effectiveness within your criminal...
HTM 424 Management Assignment #6 Instructions: You are required to answer the following questions. You should save your answers in a Word document for submission. Please do not repeat the questions...
Give an example of a cash-based ratio to measure these characteristics of an entity: (a) Liquidity (c) Profitability. (b) Solvency
The population of Detroit, Michigan, decreased from 1,027,974 in 1990 to 688,701 in 2013 (Source: U.S. Census Bureau). Find the average rate of change in the population of Detroit, Michigan, over the...
Consider the following relation: TRIP (Trip_id, Start_date, Cities_visited, Cards_used) This relation refers to business trips made by company salespeople. Suppose the TRIP has a single Start_date...
Consider the following relation: CAR_SALE(Car#, Date_sold, Salesperson#, Commission%, Discount_amt) Assume that a car may be sold by multiple salespeople, and hence {Car#, Salesperson#} is the...
Repeat Exercise 14.24 for the following different set of functional dependencies G = {{A, B}{C}, {B, D}{E, F}, {A, D}{G, H}, {A}{I}, {H}{J}}. Exercise 14.24 Consider the universal relation R = {A, B,...
Consider a $1000 face value 3-year treasury with 2.5% annual coupon and a yield of 1.3%. Suppose that after one year and after receiving one coupon payment, you decide to sell your treasury note....
How in a perfect world would muni bonds pay interest? Explain the correlation between the greater premium and high tax states. Will you invest in Muni bonds based on the new findings? Please discuss.
CityLight Co. is struggling financially. Prior to debt renegotiations, the company's total assets were $11 million and total liabilities were $18 million. The company has negotiated with the debtors...

Figure 9.8 shows an ER schema for a database that may be used to keep track of

Question:

Step by Step Answer:

SHIP SNAME OWNER TYPE PNAME SHIPTYPE TYPE TONNAG...View the full answer

Fundamentals of Database Systems

Students also viewed these Computer Sciences questions