For each relational schema below, identify PK and FK of each table. Example: Use the following...
- For each relational schema below, identify PK and FK of each table.
Example: Use the following format:
Emp (Emp#, EmpName, Dept#)
Dept (Dept#, DeptName)
Emp table:
PK: Emp#
FOREIGN KEY Dept# REFERENCES Dept (Dept#)
Dept Table:
PK: Dept#
FK: None
- Game database (5)
Game (GameID, GameTitle, GenreID, PublisherID, SeriesTitle, GamePrice, GameYear)
Genre (GenreID, GenreTitle)
Publisher (PublisherID, PublisherName, PublisherCountry, PublisherAddress, PublisherPhone)
Homework Answers
Dear Student ,
As per the requirement submitted above , kindly find the below solution.
Game database :
Game table :
- PK:GameID
- FK:FOREIGN KEY GenreID REFERENCES Genre (GenreID)
- FK:FOREIGN KEY PublisherID REFERENCES Publisher (PublisherID)
Genre table :
- PK:GenreID
- FK:None
Publisher table :
- PK :PublisherID
- FK:None
NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.
Add Answer to:
For each relational schema below, identify PK and FK of
each table.
Example: Use the following...
Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each...
Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each relation sachem should have a primary key (PK) when you answer. • To present the reference table of the foreign key (e.g., FK, FK1, K2), use an arrow. Do not use the relationship cardinality symbols of crow's foot notation in the relational database schema. o It is not required to specify the domain constraint (e.g., data type and length) of each attribute. 1. (12...
TM-315 DATABASE SYSTEMS Please help me to draw an ERD and the Relational Schema and please...
TM-315 DATABASE SYSTEMS
Please help me to draw an ERD and the Relational Schema and
please mark the Primary and Foreign Key .....
Deliverable:
Word document with grade sheet followed by Part 1 ERD and the
Part 2 relational schema.
Part 1: Draw the ERD for the following situation. 8 pts
Be sure to:
Convert all many-to-many relationships to associative
entities.
Make sure each regular entity has an appropriate identifier.
Make sure attribute names are unique within the ERD
Wally...
Question: Use the technique of normalization to validate the structure of your relational schema. Demonstrate that...
Question: Use the technique of normalization to validate the structure of your relational schema. Demonstrate that each of your relations is in third normal form (3NF) by displaying the functional dependencies between attributes in each relation. Note, if any of your relations are not in 3NF, this may indicate that your ER model is structurally incorrect or that you have introduced errors in the process of deriving relations from your model. The Relational Schema is as follows: Department (deptName, phone,...
Answer each of the following questions. The questions are based on the following relational schema: Emp(*eid:...
Answer each of the following questions. The questions are based on the following relational schema: Emp(*eid: integer¬, ename: string, age: integer, salary: decimal, doj: date) Works(*eid: integer, *did: integer, no_of_hours: integer) Dept(*did: integer, dname: string, budget: real, managerid: integer) a) Give an example of a foreign key constraint that involves the Dept relation. b) What are the options for enforcing this constraint when a user attempts to delete a Dept tuple? c) Define the Dept relation in SQL so that...
Assignment 7 Activities: Using the order form below identify entities to be used in a relational...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
VEND CODE -> VEND NAME Perry Computer Inc. uses the following INVOICE table keep track of...
VEND CODE -> VEND NAME Perry Computer Inc. uses the following INVOICE table keep track of their data. Relational schema is listed below. INVOICE (INV NUM, PROD NUM, SALE_DATE, PROD_DESCRIPTION, VEND_CODE, VEND_NAME, NUM SOLD, PROD_PRICE) Where: INV NUM -> SALE DATE PROD NUM-PROD DESCRIPTION, VEND_CODE, VEND NAME, PROD PRICE QUESTION: C. Propose a better design (with no data redundancy) and indicate the normal form of your table(s). Please use relational schema format like the INVOICE table in Perry's original design....
QUESTION B1. (7 marks) This question assumes the following relational schema Employee (employeeNumber, lastName, firstName, DOB,...
QUESTION B1. (7 marks) This question assumes the following relational schema Employee (employeeNumber, lastName, firstName, DOB, HireDate, Position Salary, Dept) Primary Key: employeeNumber Foreign key: Dept refers to DeptID in Department Department (DeptID, DeptName, DeptLocation) Primary Key: DeptID You have been given the following MySQL stored procedure: CREATE PROCEDURE Find_EmployeeName (IN employeeNo INT (11), OUT employeeName VARCHAR (60)) BEGIN SELECT concat(firstName, '', lastName) INTO employeeName FROM employees WHERE employeeNumber employeeNo; END (a) (2 marks) Name the two types of parameters...
Need help completing this schema below. 2. (3.14 Elmasri-6e)- Consider the following six relations for an...
Need help completing this schema below.
2. (3.14 Elmasri-6e)- Consider the following six relations for an order-processing database application in a company CUSTOMER (Cust#, Cnam City) ORDER (Orderf., Qdate Custf. QrdAmt ORDER ITEM (Order, Item#, Qty) ITEM Citen Unitaptice) SHIPMENT (Order Warehouse Ship. date) WAREHOUSE (Warehouses City) Here, Qrd Amt refers to total dollar amount of an order, Qdate is the date the order was placed; Ship.date is the date an order (or part of an order) is shipped from...
Write SQL Queries Given the following tables (7pts) Retrieve the names of employees and their project...
Write SQL Queries Given the following
tables
(7pts) Retrieve the names of employees and their
project name. If the employee never worked on a project, show the
names only the name, not the project name.
(7pts) Retrieve the names of employees who have worked
on the same project at a different location.
(7pts) Retrieve the names of employees who have worked
on more than two different projects.
(7pts) Retrieve the names of employees who manage more
than two employees.
CREATE...
3. (20 POINTS) Consider the LIBRARY relational database schema below to write down the relational algebra...
3. (20 POINTS) Consider the LIBRARY relational database schema below to write down the relational algebra expressions for the following two queries. No SQL statements are required. BOOK Bookid Title Publisher name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book d Branch Id No o copies BOOK LOANS Book Branch Id Card no Date out Due date LIBRARY BRANCH Branch Branch name Address BORROWER Card Name Address Phone 3.A.) (10 POINTS) Let the number of...
Part I. Mapping an (E)ER schema to a relational database schema (46 points) NOTE o Each relation sachem should have a primary key (PK) when you answer. • To present the reference table of the foreign key (e.g., FK, FK1, K2), use an arrow. Do not use the relationship cardinality symbols of crow's foot notation in the relational database schema. o It is not required to specify the domain constraint (e.g., data type and length) of each attribute. 1. (12...
TM-315 DATABASE SYSTEMS
Please help me to draw an ERD and the Relational Schema and
please mark the Primary and Foreign Key .....
Deliverable:
Word document with grade sheet followed by Part 1 ERD and the
Part 2 relational schema.
Part 1: Draw the ERD for the following situation. 8 pts
Be sure to:
Convert all many-to-many relationships to associative
entities.
Make sure each regular entity has an appropriate identifier.
Make sure attribute names are unique within the ERD
Wally...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
VEND CODE -> VEND NAME Perry Computer Inc. uses the following INVOICE table keep track of their data. Relational schema is listed below. INVOICE (INV NUM, PROD NUM, SALE_DATE, PROD_DESCRIPTION, VEND_CODE, VEND_NAME, NUM SOLD, PROD_PRICE) Where: INV NUM -> SALE DATE PROD NUM-PROD DESCRIPTION, VEND_CODE, VEND NAME, PROD PRICE QUESTION: C. Propose a better design (with no data redundancy) and indicate the normal form of your table(s). Please use relational schema format like the INVOICE table in Perry's original design....
QUESTION B1. (7 marks) This question assumes the following relational schema Employee (employeeNumber, lastName, firstName, DOB, HireDate, Position Salary, Dept) Primary Key: employeeNumber Foreign key: Dept refers to DeptID in Department Department (DeptID, DeptName, DeptLocation) Primary Key: DeptID You have been given the following MySQL stored procedure: CREATE PROCEDURE Find_EmployeeName (IN employeeNo INT (11), OUT employeeName VARCHAR (60)) BEGIN SELECT concat(firstName, '', lastName) INTO employeeName FROM employees WHERE employeeNumber employeeNo; END (a) (2 marks) Name the two types of parameters...
Need help completing this schema below.
2. (3.14 Elmasri-6e)- Consider the following six relations for an order-processing database application in a company CUSTOMER (Cust#, Cnam City) ORDER (Orderf., Qdate Custf. QrdAmt ORDER ITEM (Order, Item#, Qty) ITEM Citen Unitaptice) SHIPMENT (Order Warehouse Ship. date) WAREHOUSE (Warehouses City) Here, Qrd Amt refers to total dollar amount of an order, Qdate is the date the order was placed; Ship.date is the date an order (or part of an order) is shipped from...
Write SQL Queries Given the following
tables
(7pts) Retrieve the names of employees and their
project name. If the employee never worked on a project, show the
names only the name, not the project name.
(7pts) Retrieve the names of employees who have worked
on the same project at a different location.
(7pts) Retrieve the names of employees who have worked
on more than two different projects.
(7pts) Retrieve the names of employees who manage more
than two employees.
CREATE...
3. (20 POINTS) Consider the LIBRARY relational database schema below to write down the relational algebra expressions for the following two queries. No SQL statements are required. BOOK Bookid Title Publisher name BOOK AUTHORS Book id Author name PUBLISHER Name Address Phone BOOK COPIES Book d Branch Id No o copies BOOK LOANS Book Branch Id Card no Date out Due date LIBRARY BRANCH Branch Branch name Address BORROWER Card Name Address Phone 3.A.) (10 POINTS) Let the number of...
Most questions answered within 3 hours.
-
Identical twins come from a single egg that split into two
embryos, and fraternal twins are...
asked 9 minutes ago -
The chemical formula for any CFC, HCFC, or HFC can be obtained
by adding 90 to...
asked 12 minutes ago -
Price discrimination adds to social welfare in the form of
(i)
increased total surplus.
(ii)
reduced...
asked 6 minutes ago -
Find and Sketch 6 point circular convolution of two sequences;
N=6
x[n] = [1,2,3,4]
h[n]= [0,0,1,0]
asked 21 minutes ago -
Using c# visual studio
Game of Life
The Game of Life program assignment follows the material...
asked 13 minutes ago -
True or false
Andrea owes Joe $75,
due on Monday. She cannot get him the money...
asked 20 minutes ago -
Sunshine Company only produced one product and has the following
costs:
Number of units produced each...
asked 28 minutes ago -
What must her minimum speed be just as she leaves the top of the
cliff so...
asked 33 minutes ago -
10.2 Calculate the energy that must be absorbed in stopping a
100 tonne airbus airliner travelling...
asked 37 minutes ago -
Q3- What are the pro’s and con’s of using a web farm?
Please no hand
writing,...
asked 43 minutes ago -
For a nonpolar solute, why does the mobile phase strength
increase as the solvent becomes less...
asked 48 minutes ago -
The times per week a student uses a lab computer are normally
distributed, with a mean...
asked 55 minutes ago