Database Management System

Complete the following exercises in Connolly & Begg:

4.8 The following tables from part of a database held in a relational DBMS

Hotel (hotelNo, hotelName, city)

Room (roomNo, hotelNo, type, price)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Guest (guestNo, guestName, guestAddress)

a) Identify the foreign keys in this schema.

b) Explain how the entity integrity rule and the referential integrity rule apply to these relations.

5.8 Describe the relations that would be produced by the following relational algebra operations. In your description, make clear what attribute your relations have, and explain what each relation represents in the real world.

a) π_hotelNo(σ_{price > 50}(Room))

b) σ_{Hotel.hotelno = Room.hotelNo}(Hotel × Room)

c) π_hotelName(Hotel ⨝ _{Hotel.hotelNo = Room.hotelNo}(σ_{price > 50}(Room)))

The following tables form part of a Library database held in an RDBMS:

Book (ISBN, title, edition, year)

BookCopy (copyNo, ISBN, available)

Borrower (borrowerNo, borrowerName, borrowerAddress)

BookLoan (copyNo, dateOut, dateDue, borrowerNo)

Formulate the following queries in relational algebra:

5.24 List all book titles

5.25 List all book titles published in the year 2012.

5.27 List all copies of book titles that are available for borrowing.

5.30 List the names of borrowers with overdue book.s

Consider the schemas of the following relational database for a company. The company has different departments at different cities in different states:

employee(employee-id, dept-id, name, street-num, street-name, city, state, zip, salary)

department(dept-id, dept-name, city, state)

manager(manager-id, employee-id)

NOTES:

manager-id in the manager relation is a foreign key to the employee relation.

employee-id in the manager relation is a foreign key to the employee relation.

dept-id in the employee relation is a foreign key to the department relation.

An employee belongs to a single manager only. That is, an employee only works for one manager. Some employees do not have a manager (in that case, they do not have an entry in the manager relation).

Write SQL statement (no computer work is needed) for each of the following queries.

1. Find all managers (manager-ids and names) who’s department located in California (state = ‘CA’).

1. Find all employees (IDs and names) in the database who do not work for the Research Department.

1. Anita Jones got married and she wanted to change her name to Anita Smith. Modify the database so that Anita Jones becomes Anita Smith (her employee-id is 987654321).

1. Delete all tuples in the manager relation for manager-id = 123456789.

Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. “Query 1” and “Step 1” are examples of poor names.

Step 1

Build a Database named DBMS Course Project. The database should include the following tables:

• First Table – Students
  • ID
  • First Name
  • Last Name
  • Address
  • City
  • State
  • Zip Code
  • Phone Number with area code
• Second Table – GPA
  • ID Current GPA (two decimal positions)
  • Class (numeric field, 1 = Freshman, 2 = Sophomore, etc.)
    • Freshman
    • Sophomore
    • Junior
    • Senior
    • Graduate Student
• Third Table – Scholarships
  • ID
  • Major course of study
  • Academic Scholarship (Use Yes/No data type)
  • Athletic Scholarship (Use Yes/No data type)

Step 2

Extract the First and Last Name, Address, City, State, Zip Code and Phone Number of each Senior on the database. Sort by Last Name, then First Name (1 sort).

Step 3

Extract the First and Last Name, and GPA of each student who qualifies for the Dean’s List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean’s List.

The discussion 2 topic is "The National Center for Health Statistics had change the Standard Population for Age Standardization of Death Rates from 1940 to 2000. Discuss how it affected the age-adjusted rates of mortality. Discuss any one method of adjusted rate (direct / indirect). "

Discuss (direct) 150 to 200 words

Data of 1940 to 2000

Assume that your firm was auditing General Electric in 2000 and was recommending an adjustment to its financial statements that reduced net income. Based on the fees paid to your firm in 2000, what incentive(s) might your firm consider in insisting upon this adjustment? How would your firm's incentive(s) differ after 2004?

Let's go to the movies: A random sample of 43 Foreign Language movies made since 2000 had a mean length of 112.5

minutes, with a standard deviation of 12.6 minutes.

Construct a 95% confidence interval for the true mean length of all Foreign Language movies made since

2000. Round the answers to one decimal place.

CD interest rates vary significantly with time. They hit a historical high in 1981, when the average rate was 16.7%. In 2000, it was 8.1%. In 2009, it was 2%. Find the interest earned by a $3000 two-year CD with interest compounded quarterly in each of the following years. (Round your answers to the nearest cent.)

(a) in 1981 $

(b) in 2000 $

(c) in 2009 $

c++

I need a code that will fill an array size of 1000, an array of size 2000, and an array size of 10000, with random int values.

Basically like this:

array1[1000] = filled all with random numbers

array2[2000] = filled all with random numbers

array3[10000] = filled all with random numbers

C++

no need for print

1. Calculate the future value of these deposits. Remember to total your answer. Assume end of year deposits.

Part a:

n          Deposit            Terms                          FVIF               $

1          $1000              5%, semi-annual

2          $1500              6%, monthly

3          $2000              8%, quarterly

4          $1000              12%, annual

5          $2000               8%, semi-annual

Suppose the market for oranges is perfectly competitive and unregulated. Suppose also that the chemicals used to keep the oranges insect-free damage the environment by an estimated $1 per bushel of oranges.

a) Suppose QD = 2000 - 200P and QS = -200 + 200P. The total dollar value damage to society is?

b) Suppose QD = 2000 - 200P and QS = -200 + 200P. The price consumers would have to pay for the market to achieve the socially optimal level of production is?

c) Suppose QD = 2000 - 200P and QS = -200 + 200P. The tax that would have to exist to achieve the socially optimal level of production would be

Show all the steps to get full credit

plz hurry