1) True or False - The foreign keys in a table are linked to the primary keys in another tables
2_ When we convert this ER to relations, which relation will represents the check entity:
|
Check( account_number,check_number, check_date ,recipient,amount,memo) |
|
|
Check( check_number, check_date ,recipient,amount,memo) |
|
|
Check( check_date ,recipient,amount,memo) |
|
|
Check( account_number, check_date |
3)
When we convert this ER to relation, we will have:
hint: address is multi-valued attribute
Question 4 options:
|
customer(cust_id,name) address(cust_id,street,city,state,zipcode) |
|
|
customer(cust_id,name, street,city,state,zipcode) |
|
|
customer(cust_id,name) |
|
|
address(cust_id,street,city,state,zipcode) |
Homework Answers
Add Answer to:
1) True or False - The foreign keys in a table are
linked to the primary...
[1] [30 points] Consider the relation R City, Street, Zip Code), where a tuple (c, s,...
[1] [30 points] Consider the relation R City, Street, Zip Code), where a tuple (c, s, z) is in R only if city c has a building with street s, and z is the zipcode for that address in that city. It is assumed that the nontrivial functional dependencies are: Street → Zip Code ZipCode → City City, [a] [b] [C] [d] [e] Determine all possible keys for R. Indicate all possible BCNF and 3NF violations. Decompose R as necessary...
Please convert figure 9.9 in p305 into relational schemas. In the table, the primary key and...
Please convert figure 9.9 in p305 into relational
schemas.
In the table, the primary key and foreign keys (arrows)
must be identified.
Engin size CAR Vin Price VEHICLE d TRUCK Tonnage Model N Date SUV No seats SALE SALESPERSON CUSTOMER Address City Street Sid Name Ssn State Name Figure 9.9 EER diagram for a car dealer
Database: Convert E-R diagrams to relational schema and show • Primary Keys (using underline) • Foreign Keys (using dotted underline) • Referential Integrity Convert the E-R diagrams to relational s...
Database: Convert E-R diagrams to relational schema and show
• Primary Keys (using underline)
• Foreign Keys (using dotted underline)
• Referential Integrity
Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer...
Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer Refers State City City Address Address State Zip Code Street Holds Zip Code Merchant Card Type AccountID Card Account Has Exp Date Charge Date Charge Time Card Type = "C Debit Card Credit Card Has Charges Current Balance Bank No. Amount
The primary keys are underlined. The foreign keys are denoted by asterisks (*). Description of the...
The primary keys are underlined.
The foreign keys are denoted by asterisks (*).
Description of the schema:
• person — keeps track of the people who borrow books from the
library. The attributes contain personal and contact
information.
• author — keeps track of personal information about authors.
• publisher — keeps track of the publisher information. To keep it
simple, most of the attributes have been truncated in the sample
database. 1 trivial dependencies are things like X→X or...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I att...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...
I would like help with this question and please be clear and thank you for the...
I would like help with this question and please be clear and
thank you for the help.
Produce a relational schema diagram that corresponds to the following ER diagram for a Vacation Property Rentals database. Your relational schema diagram should include primary & foreign keys. Upload your relational schema diagram as a PDF document. Don't forget that the relation schemas for "Beach Property" and "Mountain Property" should each have primary keys. FYI: "d" in this notation denotes a subclass. Figure...
For this DATABASE homework assignment you will create an Entity Relationship model for a business case...
For this DATABASE homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations. Read through the following business case for the “Drum Corps International” Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data requirements. All relationships should be labeled with verb phrases. Use UML notation for this work. Relationship lines should not cross. ...
NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR...
NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR FOREIGN etc Customer [ CustID, LastName, FirstName, Address, City, State, Zip, Phone, Fax, Email] Product [ ProdID, Description, Color, Size, Pack] Sales [ TransID, CustID, ProdID, Price, Quantity, Amount] Write SQL statement to produce a list of unique products and their prices from the Sales table. Please ensure that the products do not repeat. Write an SQL statement to list ProdID and Description for...
[1] [30 points] Consider the relation R City, Street, Zip Code), where a tuple (c, s, z) is in R only if city c has a building with street s, and z is the zipcode for that address in that city. It is assumed that the nontrivial functional dependencies are: Street → Zip Code ZipCode → City City, [a] [b] [C] [d] [e] Determine all possible keys for R. Indicate all possible BCNF and 3NF violations. Decompose R as necessary...
Please convert figure 9.9 in p305 into relational
schemas.
In the table, the primary key and foreign keys (arrows)
must be identified.
Engin size CAR Vin Price VEHICLE d TRUCK Tonnage Model N Date SUV No seats SALE SALESPERSON CUSTOMER Address City Street Sid Name Ssn State Name Figure 9.9 EER diagram for a car dealer
Database: Convert E-R diagrams to relational schema and show
• Primary Keys (using underline)
• Foreign Keys (using dotted underline)
• Referential Integrity
Convert the E-R diagrams to relational schema and show: Primary Keys (using underline) Foreign Keys (using dotted underline) . Referential Integrity Your schema should look similar to the example below. CUSTOMER CustName ORDER PROJECT Foect Title EMPLOYEE PROJECT assigecl to Tite BBli EMPLOYEE PROJECT 0 ProectTitle 4 student admitdate D,C gradstudent advisor major mimor class person name...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
Question 1: Please transform the following E-R diagram to relations (40 points) CID Name Street Customer Refers State City City Address Address State Zip Code Street Holds Zip Code Merchant Card Type AccountID Card Account Has Exp Date Charge Date Charge Time Card Type = "C Debit Card Credit Card Has Charges Current Balance Bank No. Amount
The primary keys are underlined.
The foreign keys are denoted by asterisks (*).
Description of the schema:
• person — keeps track of the people who borrow books from the
library. The attributes contain personal and contact
information.
• author — keeps track of personal information about authors.
• publisher — keeps track of the publisher information. To keep it
simple, most of the attributes have been truncated in the sample
database. 1 trivial dependencies are things like X→X or...
c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary. Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same...
I would like help with this question and please be clear and
thank you for the help.
Produce a relational schema diagram that corresponds to the following ER diagram for a Vacation Property Rentals database. Your relational schema diagram should include primary & foreign keys. Upload your relational schema diagram as a PDF document. Don't forget that the relation schemas for "Beach Property" and "Mountain Property" should each have primary keys. FYI: "d" in this notation denotes a subclass. Figure...
Most questions answered within 3 hours.
-
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 9 minutes ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 1 hour ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 1 hour ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 1 hour ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 1 hour ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 2 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 2 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 2 hours ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 2 hours ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 2 hours ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 2 hours ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 2 hours ago