SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Dec 2017 My Price 10.00

CUSTOMER (customerID, customer_name, street, city, zip)

Question 3.                                                                                          <20 points>

 

Given the following movie rental database:

 

CUSTOMER (customerID, customer_name, street, city, zip)

RENTAL (rentalID, rental_date, return_date, due_date, customerID, movieID)

MOVIE (movieID, movie_title, movie_desc)

 

Where the primary keys are underlined with a solid line and any foreign keys are underlined with a dashed line, give an expression in SQL for each of the following queries:

 

  1. Display the customer name for all customers that rented the movie ‘TOP_GUN’. (4 points)
  2. Display the customer name for all customers that rented the movie ‘TOP GUN’ and the return date was past the due date. (4 points)
  3. Display the customer name for all customers that rented the movie ‘TOP GUN’, that have passed the due date, and that have not returned the movie yet. (hint: SYSDATE and NULL should be used) (4 points)
  4. Display the movie title of all movies that have ‘ANIMAL’ somewhere in the title or in the movie description. (hint: use the LIKE keyword) (4 points)
  5. Display the number of customers that have outstanding rentals. (hint: use a SQL function to accomplish this) (4 points)
  6.  
  7.  
  8.  

 

Question 4                                                                                 <20 points>

 

Part 1.  

 

 

  1. Consider a database used in a doctor’s office. Construct an ERD that defines ternary relationship to record information about patients, doctors, and treatment. (5 points)
  2.  
  3. Consider a business that needs to store data about its employees. The business rules for the relationship between employees and managers is listed below. Construct the portion of the ERD that satisfies the rules. Note: Your diagram should only contain one entity. (5 points)
  4.  
  5. Business Rules:
  6. An EMPLOYEE can manage one or more EMPLOYEEs
  7. An EMPLOYEE can be managed by one and only one EMPLOYEE
  8.  
  9.  
  10. Part 2.  
  11.  
  12. Consider a real estate company that rents as well as sells properties. Using the following list of entities, construct an ER diagram that satisfies the following business rules. If any many-to-many relationships exist, resolve them by creating bridge/composite entities. (10 points)
  13.  
  14. Entity List: 
  15. CUSTOMER, PROPERTY
  16.  
  17. Business Rules:
  18. A CUSTOMER can rent one or more PROPERTIES
  19. A PROPERTY can be rented by one or more CUSTOMERs
  20.  
  21. A CUSTOMER can purchase one or more PROPERTIES
  22. A PROPERTY can be purchased by one or more CUSTOMERs

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 12 Dec 2017 08:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)