1. Engineering
  2. Computer Science
  3. question 1 5 points list three applications you have used...

Question: question 1 5 points list three applications you have used...

Question details

Question 1 (5 Points): List three applications you have used that most likely employed a database system to store data. For each application, explain what data view each of the following would like to see: 1. Someone at company leadership 2. Someone at middle managemest 3. Someone facing customers Question 2 (4 Points): Given the table structure shown below, answer the following questions: project_cde project manager manager phone manager address project bid manager pay 21-5Z Holly B. Parker 904-338-3416 75000.00 3334 Lee Rd Gainsville, FL 37123 1683346.00 25-2D Jane D. Grant 615-898-9909 218 Clark Blvd, Nashville, TN 36362 1250000.00 78000.00 25-5A George F. Dorts 615-227-1245 124 River Dr. Franklin, TN 29185 3251242.00 77000.00 25-9T Holly B. Parker904-338-3416 3334 Lee Rd Gainsville, FL 37123 2156323.00 75000.00 27-4Q George F. Dorts 615-227-1245 77000.00 124 River Dr. Franklin, TN 2918 1031454.00

Given the table structure shown below, answer the following questions: project_cde project manager manager_phone manager_address project_bid manager pay 21-5Z Holly B. Parker 904-338-3416 3334 Lee Rd Gainsville, FL 37123 1683346.00 75000.00 Jane D. Grant 615-898-9909 218 Clark Blvd., Nashville, TN 36362 1250000.00 78000.00 25-5A George F Dorts 615-227-1245 124 River Dr Franklin, TN 29185 3251242.00 25-9T Holly B. Parker904-338-3416 3334 Lee Rd., Gainsville, FL 37123 2156323.00 75000.00 27-4Q George F. Dorts 615-227-1245 124 River Dr. Franklin, TN 29185 1031454.00 77000.00 29-2D Holly B. Parker904-338-3416 34 Lee Rd. Gainsville, FL 37123 2555999.00 75000.00 31-7P William K. Moor 904-445-2719 216 Morton Rd Stetson, FL 30155 5685000.00 79000.00 43-3R William K. Moor 904-445-2719 216 Morton Rd Stetson, FL 30155 458769.00 79000.00

media%2F8da%2F8dae5a50-eac3-45ac-a16d-ae

Job Benefit emp code EC15 EC16 EC17 EC17 EC17 EC20 escription lan code C1 JC2 JC2 JC3 cal Technical BA Extra Benefit job code blan code Assume that the following attributes are the primary keys for the tables emp_code is the primary key for Employee table job code is the primary key for the Job table plan_code is the primary key for the Plan table emp_code, plan_code job_code, plan_code is the composite primary key for the Extra_Benefit table is a composite primary key for the Benefit table

. (2 Points) Do all tables exhibit entity integrity? Answer yes or no and then explain your answer for each table 3.2 (2 Points) For each table in the database, identify foreign key(s) (if any). For each foreign key, state the referencing relation and the referenced relation. 3.3 (2 Points) Do all tables exhibit referential integrity? Answer yes or no and then explain your answer for each table Question 4 (5 Points): Given the following relational database schema (primary keys are bold and underlined) Answer questions 2.1 to 2.4: branch(branch id branch name, branch_city, assets) cust name, customer _street, customer_city, customer_st, customer_zip) tomer(customer id customer loanloan number branch id, amount) borrower(customer id loan number) account account number branch depositor(customer id, account number) id, balance) 2.1 3 Points) For each of the following queries, write a relational algebra expression to answer the query:

2.1 (3 Points) For each of the following queries, write a relational algebra expression to answer the query a) Find the names of all customers who live in Hopkins and have the name Brewster. b) Find the names and zip codes of all customers who have loans. c) Find the names, cities of residence, and state for all depositors who have accounts with balance that is less than $3500 2.2 (2 point) For each of the following relational algebra expressions, explain the output of the expression in words: allbranch name(obranch-city=chicago( branch) b. Illoan number(ơbranch name=mankato 1 stave, (branch oan) 0 Type here to search

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution