3. StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the short- hand representation and a diagram of your choice. a. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. b. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. C. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.

3. StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the short- hand representation and a diagram of your choice. a. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. b. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. C. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

8. The head of the hospital’s accounting department is concerned about the prescribed charge for services versus the actual charges for services in the surgery category of services (service_cat_id = ‘SUR’). Produce a listing of surgery services listed in the treatment table by service_id where the prescribed service_charge differs from the actual_charge recorded in the treatment table. The result table should also include the service_charge and actual-charge. Use a subquery approach to produce a listing of service_id values from the service table that belong to the ‘SUR’ category of services. Display the SQL code written
Using the database schema attached, write SQL query for these statements: (1) List stores with more than 200 customers. (2) Display the average amount paid by each customer, along with the customer's first and last name.
i need code sql THE TABLES (PROJECT, DEPARTMENT, EMPLOY). • Each EMPLOY has (nemp, ID number, ndept, nproj,salary) NEMP NOT NULL VARCAHR(30) PRIMARY KEY, ID_NUMBER(10) NOT NULL, NDEPT VARCAHR(15), NPROJ VARCAHR(7) PRIMARY KEY, SALARY NUMBER(17). Requirements • Each PROJECT has (nproj, ndept,nemp) NPROJ VARCAHR(15) NOT NULL FOREGIN KEY KEY, NEMP VARCAHRH(30) PRIMARY KEY, NDEPT VARCAHR(10). • Each DEPARTMENT has(ndept, number nemp) Number NUMBER(3), NDEPT VARCAHR(30) NOT NULL, NEMP VARCAHR(15) FORGEIN KEY. Entity Relationship THE EMPOLY HAS A NEMP AND NPROJ AS PRIMARY KEY WILL CONACTED TO BOTH DEPARTMENT AND PROJECT AS FOREIGN KEY. THE PROJECT HAS A NPROJ AS FORGIEN KEY WILL CONACTED TO EMPOLY AS PRIMARY KEY. THE DEPARTMENT HAS A NEMP AS FORGIEN KEY WILL CONACTED TO BOTH EMPLOY AND PROJECT AS PRIMARY KEY. (RELASHINSHEP: EVERY DEPARTMENT has PROJECT and EVERY EMPLOY work on PROJECT and work in DEPARTMENT)
Assume that you are hired to design a relational database to "manage" the thesis and the projects done in an academic department. Write a maximum 5 pages executive summary which will serve as the requirements analyses document. Your exec summary should provide the following information. No SQL implementation is required at this stage. Stake holders (not just the bare end users) End users Expected functionalities (i.e., sample queries in English, not in SQL) Relation/Tables with the attributes Primary key(s) for each table.
Using the film database you have, answer the following queries in your schema thenwrite them down in this paper.Question One:a) Select the total rental_rate for films grouped by their categories. Order the resultfrom largest to smallest. b) Select all actors who acted together with JOE in any film. Use inner query. c) Create a view, which has category names and number of films each category has.
Q: 2. Create the database name Company which consists of one Entity name Employee which consists of 10 attributes (ID/First Name/Last Name/CNIC/Gender/Department/Sal ary/Address/Age) ID should be primary key Insert at least 10 records in the Entity Employee with respect to their type. a) Implementation the example of stored procedure now creates the stored procedure which: a. Have an ability to insert the record in the table. b. Have an ability to delete the record in table. c. Have an ability to update the record in the table. d. Have an ability to display the record in the table. |
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
You are asked to design a database for an auto insurance company Green Angel that satisfies the following requirements: a. Green Angel has several local offices. Each local office has a unique number, a unique name, an address, and a telephone number. A specific employee who manages the local office. b. The employee record includes social security number, name, address, phone number, date of birth, sex, and salary. Every employee works for a local office. c. Green Angel has several insurance plans. Each plan has a unique code, a fixed premium, a set of criteria for the people who are eligible for the plan. The set of criteria include age range, sex, and the state of residence. d. A subscriber has a unique subscriber's number, name, date of birth, sex, address, telephone number, insurance plan and the employee that handles the subscriber's paper work. Some queries access the records by the last name of the subscriber. Some queries need to refer to the zip code in the address. e. Each…
Create an employee table and perform the following queries. • Rename the table from "Employee" to "Emp1" • Display the details of the employees where the salary of employee is less than the Avg. salary of organization. • Display the information of employees belongs to CSE department and having experience greater than 10 years. Delete all records where performance grade is "Not satisfactory"