!10:211.Using your DBMS Create a databaand table for the following datapresented below.Rental Order Processed ByEmployee #: 28005Rental Order Processed ForDrv. Lie. #: P244-957-279Full Name:Address:City:State:ZIP Code:Mileage and Time InformationMileage Start: 10407Rental SummaryRate Applied:Notes:Post, William808 Lennard Rd.Takoma ParkMD20910NavigatorSCHEMASa Fiter objectsYdbemployeeTablesstaffColumnsrectoempidInamefnameageaddressStarr, PatrickIndexesForeign KeysTriggersHere is the sample screen shot to besubmitted.Viewsored Procedures=56.95 Order Status: Rented - Car On RoadThe customer plans to rent the car for the whole week.Start Date:6Car RentedTag Number: 4FP208Make:AcuraModel:RDXDoors/Seats: 4/4Condition: ExcellentTank Level: Full7891011OTROS Limit to 1000 rows14 CREATE DATABASE bemployee;20 O CREATE TABLE tblstaff(34502/10/2014}}recno int NOT NULL AUTO INCREMENT,expid varchar(255) NOT NULL,Iname varchar(255) NOT NULL,fname varchar(255) NOT NULL,mi varchar(255),age int,Oaddress varchar(255),PRIMARY KEY(recno)49

1.Using your DBMS Create a databa and table for the following data presented below. Rental Order Processed By Employee #: 28005 Rental Order Processed For Drv. Lie. #: P244-957-279 Full Name: Address: City: State: Post, William 808 Lennard Rd Takoma Park MD ZIP Code: 20910 Mileage and Time Information Mileage Start: 10407 Rental Summary Rate Applied: Notes: Navigator SCHEMAS ter objects dbemployee Tables bistaf Starr, Patrick Here is the sample screen shot to be submitted. Columns recto empid name frame m age address Indexes Foreign Keys Triggers Views Bored Procedures 56.95 Order Status: Rented-Car On Road The customer plans to rent the car for the whole week 1. 2. 3 4 Car Rented Tag Number: 4FP208 Make: Acura Model: RDX Doors/Seats: 4/4 Condition: Excellent Tank Level: Full Start Date: 5 6 7 8 9 NOFTRO&Lit to 1000 rows CREATE DATABASE dbesployee; CREATE TABLE tblstaff( 10 11 02/10/2014 }} recno int NOT NULL AUTO INCREMENT, expid varchar(255) NOT NULL, Inane varchar(255) NOT MILL, fnane varchar(255) NOT NULL, i varchar(255), age int, address varchar(255), PRIMARY KEY(recno)

1.Using your DBMS Create a databa and table for the following data presented below. Rental Order Processed By Employee #: 28005 Rental Order Processed For Drv. Lie. #: P244-957-279 Full Name: Address: City: State: Post, William 808 Lennard Rd Takoma Park MD ZIP Code: 20910 Mileage and Time Information Mileage Start: 10407 Rental Summary Rate Applied: Notes: Navigator SCHEMAS ter objects dbemployee Tables bistaf Starr, Patrick Here is the sample screen shot to be submitted. Columns recto empid name frame m age address Indexes Foreign Keys Triggers Views Bored Procedures 56.95 Order Status: Rented-Car On Road The customer plans to rent the car for the whole week 1. 2. 3 4 Car Rented Tag Number: 4FP208 Make: Acura Model: RDX Doors/Seats: 4/4 Condition: Excellent Tank Level: Full Start Date: 5 6 7 8 9 NOFTRO&Lit to 1000 rows CREATE DATABASE dbesployee; CREATE TABLE tblstaff( 10 11 02/10/2014 }} recno int NOT NULL AUTO INCREMENT, expid varchar(255) NOT NULL, Inane varchar(255) NOT MILL, fnane varchar(255) NOT NULL, i varchar(255), age int, address varchar(255), PRIMARY KEY(recno)

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

Describe primary data integrity constraints in SQL.
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)
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.
use sql to answer the following question an erd had been provide List all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name.
Briefly explain what is meant by referential integrity and how it is enforced bythe DBMS
Finding the necessary PL/SQL subblock is your mission. Also, please provide a brief summary of the three parts that together make up a PL/SQL block.
use sql to answer the following question an erd has been provide List all criminals along with crime status and appeal status (if applicable). The reports need to include the criminal ID, name, crime classification, date charged, appeal filing date, and appeal status. Show all criminals, regardless of whether they have filed an appeal. Hint: Join between tables criminals, crimes , appeals Inner join between criminals and crimes but LEFT JOIN with appeals