Question: Create the company database using the provided scripts. Write the queries to modify the Company database to do the following. Note that you are expected

Create the company database using the provided scripts. Write the queries

Create the company database using the provided scripts. Write the queries to modify the Company database to do the following. Note that you are expected to answer this question in sequential order (a,b,c,d). All queries in this question must work regardless of the case (uppercase or lowercase) of the data. a. Use RESTRICT for all referential integrity. Except for the following cases: - When an employee is deleted: - set FK in Employee and Department to null - delete referenced rows in Works_On and Dependent - When an employee's SSN is updated: then propagate that change to all related FKs. Note that you must first drop all existing constraints that conflict with the new conditions. Include all the required queries in your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Use the library EER diagram and the library database in UM learn to answer questions 1-4 Create the Library database Using the Script provided in UMlearn, create, and populate all tables to answer...

You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing company...

Write the relational algebra expressions for the following queries: Here is the Database. Now the questions.. toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333...

i know its a long project but please answer it based on the format below 1-Introduction 2-Data Requirements and Conceptual Design 3-Database Construction and Population 4-Querying the Database...

sage 300 system studies Bank and Tax Services The information provided in this project will allow you to set up Tax Services and Bank Services for Assignment \#1 company. Continue with your data from...

DROP DATABASE IF EXISTS Bank; CREATE DATABASE Bank; USE Bank; DROP TABLE IF EXISTS transaction; DROP TABLE IF EXISTS customer; DROP TABLE IF EXISTS account; CREATE TABLE customer ( name VARCHAR(20),...

Peaple follow each instruction to create the tabe and show the schema. respond to questions by putting number to each question you answer. The project requires building a database application for a...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

You are a small database consulting company who designs and develops databases for small to medium sized businesses. You have now been hired to design and implement a database system for the dream...

Write balanced net ionic equations for the following reactions. Supply H* and/or H,O as needed to ob- tain balance. *(a) Fe+ + Sn+ Fe?+ + Sn*+ (b) Cr(s)+Ag* Cr* + Ag(s) *(c) NO, + Cu(s) NO,(g) +...

It is said that a microhedge does not totally eliminate risk. Assume that a bank uses financial futures contracts to reduce the risk of rising rates on new borrowings. Identify what type of position...

A _ _ _ _ _ _ _ _ is a key used between entities for the purpose of distributing session keys. permanent key session key distribution key all of the above

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that...

If the employment application you submit does not have all the blanks filled in, has smudges on it, and has words crossed out, what impression might the prospective employer have about you?...

You are considering creating an online rsum for your job search. Research publishing to the Web and answer the following questions. (Objective 4) a. Where will you publish (or post) your rsum? b. Is...

Technology. Convert the rsum you developed in Application Exercise 13 to a scannable rsum using keywords throughout. E-mail a copy to your instructor. (Objective 4)