Consider the following structure of an inventory Oracle database. HUMERC (B) WOWR) VIMOHAR ( S DECL MARIC S) WOMR AME CUBT NAE OITY COMMION WOHARSS CITY GRADE MUMERIC (3) BALESMAN D MERC(S) orders ORD NO PURCH AMT MUMERIC (S) DECIMAL ( DATE ORD DATE CUSTOMER D NUMERIC (5) SALESMAN D NUMERIC (6) Display those customers who are neither from the city New York nor their grade values are more than 100.
Q: QUESTION 2 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Two Fruits can't have same name even the Fruit ID is different. Because, Name field is having UNIQUE…
Q: Consider the following relations in the relational schema for a database that keeps track of…
A: Given: Consider the following relations in the relational schema for a database that keeps track of…
Q: QUESTION 3 Consider the following database schema for a library. Book (BookiD:int,…
A: Answer :-- True
Q: Consider the following example database and query and then show the value of…
A: distance(volvo,Volvo_Distance) Volvo_Distance = speed (volvo, Speed) * time (volvo, Time) = speed…
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: Primary key of one table when used in another table is referred as foreign key. Foreign key need not…
Q: You are given the following database schema: Sailors(sid, sname, rating, age) Boats(bid, bname,…
A: Given Data : Number of pages in main memory = 9 Sailors : Tuples = 100000 pages = 1000 Sailors…
Q: QUESTION 3 Consider the following database schema for a library. Book (BookID:int,…
A: Foreign key :- A foreign key is a set of attributes in a table that refers to the primary key of…
Q: 2.Given the following database in Figure 1 Employee(ssn:int,name:string.jobTitle:string)…
A: Entity Relationship Diagram (ERD) or Entity Relationship Diagram (ERD) is a diagram that shows the…
Q: A database has four transactions. Let min_support=60% and min conf=80% TID date Items_bought T100…
A: The support and confidence are the association analysis for the performance measure. Support is all…
Q: Consider the database schema below. Fruit (ID: integer. Name: String ) Vitamin (FruitID: Integer.…
A: In the Fruit table, Name is not a primary key. Key constraint states thate all the values of primary…
Q: Consider the following Database Schema. PK CUs COOE PK OL ER contains PKFK1 ry PK CUS LNAME CUs…
A: BY USING INNER JOIN WE CAN GET THE DESIRED RESULT AND TO DISPLAY THE TABLE AS IT IS SHOWN WE NEED TO…
Q: Consider a student database where the primary key is StudentID and there are indexes on Major, Age,…
A: Information provided: A table for students is provided on the university website, with the primary…
Q: A QUESTION 6 Consider the following database schema for a library. Book (BookID:int,…
A: The instances in a database schema, as well as their relationships, are described by the schema. It…
Q: QUESTION 5 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Given: To choose correct option.
Q: The following question are based on the database whose relational schemas are emp(EMPNO, ENAME, JOB,…
A: embeddings values into table Addition INTO emp (EMPNO, ENAME, SAL, DEPTNO) Qualities (8988,…
Q: QUESTION 2 Consider the following database schema for a library. Book (BookID:int…
A: Entity integrity constraints The entity integrity constraint states that primary key value can't be…
Q: The figure below shows an ER schema for a university database. Map this ER schema into a relational…
A: Since the question refers to a mapping algorithm which is not described in the question we are going…
Q: Question 1 - Apriori Algorithm - Given the following transaction database: Transaction ide Itemse…
A: a) Given minimum support = 50%. Total number of items = 5 So, minimum support count = (number of…
Q: In a database, there are values a data element can take, and there are values it cannot take. In…
A: The answers are given in below sections for each with explanation .
Q: Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME…
A: Answer :- Play entity: Primary Key: PLAY_CODE Explanation : - because using PLAY_CODE you can find…
Q: Exercise 1 Part 2 Consider the following information about the university database, D Professars…
A: The ER Diagram that follows is based on the information provided in the university question.
Q: Suppose you want to store the records of the employees of your company. They all have employee ID's…
A: Actually, java is a object oriented programming language. It is a platform independent.
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: The question is to choose the correct option from the given options in the question.
Q: Consider the database schema below. Fruit (ID: integer, Name: String ) Vitamin (FruitID: Integer.…
A: - We need to select the correct among the provided for the provided relation. - The question is to…
Q: b) Consider a simple relational database of Hospital Management System. (Underlined attributes…
A: 1. SELECT PatientID FROM Patients As P , Hospital As H WHERE P. PatientID =H.PatientID…
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: The answer is ,no,it violates the domain constraint. Below is explanation:
Q: Consider the relational database below, where the primary keys are underlined. employee…
A: As per guidelines, I'm supposed to answer first 3 part of the given questions. Repost the other…
Q: Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique),…
A: No, It Is Not Possible to have a Borrowing-Record with an unknown CustomerCPR.
Q: I need the answer as soon as possible
A: The above question the 4 relation schema and explain and the find a weak entity in the below step
Q: Suppose you have the following relational database scheme for a real estate agency: Real Estate…
A: Solution:
Q: QUESTION 5 Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin…
A: Two tables are given with primary key ID in fruit table. Vitamin table has composite key fruitID…
Q: Consider the following relational database schema that contains information about employees and…
A: {pid,pname} {pid,pname,budget} {pname,managerid} {pname,budget,managerid}
Q: With the following Object Oriented Relational Database schema, select the attributes that a tuple in…
A: Actually, A relational database is a type of database that stores and provides access to data…
Q: Consider the database schema below for hotels in countries. A country have many hotels, and the same…
A: Data Base Management System: DBMS is a software that is used to store, manage and use database…
Q: Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique),…
A: CPR is the type of int
Q: Calculate the I/O cost of sorting the Sailors relation
A: Let's see what are we given. We have available 9 pages in the main memory. Solution 1) Given that…
Q: Balanced tree is one of the data access techniques in database. How does it work? How data can be…
A: Actually, given question regarding balanced tree.
Q: QUESTION 7 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Incorrect options Referential Integrity Constraint :A foreign key should have a primary key that…
Q: Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin (FruitID:…
A: Here for the relation Vitamin, primary key is (FruitID, VitaminName) It means for any row, if values…
Q: (c) The following relational schema form part of a database held for library borrowing system.…
A:
Q: Student(student Number, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber,…
A: The relational algebra for the given query is as follows,
Q: Select from below ALL statements that are true. Select one or more: a. Adding locking and…
A: Answer and explanation is provided in the following steps.
Q: QUESTION 6 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Given: To choose the correct option.
Q: QUESTION 2 Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin…
A: EXPLANATION: The entity set that is utilized to uniquely identify an entity inside its entity set…
Q: 4. Consider the following GRADEBOOK relational schema describing the data for a grade book of a…
A: Relation schema defines the design and structure of the relation like it consists of the relation…
Q: Assume that a student table in a university database had index on StudentID (the primary key) and…
A: Given information: A student table is given in the university website with an index on StudentlD as…
Q: A student database may include indexes on fields such as major, age, marital status, and home zip…
A: Information disclosed: On the university website, a table of students is provided, with an index on…
Q: Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME DIR_NUM 1001…
A: Given:- Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME…
Step by step
Solved in 2 steps
- The following tables provide a very small portion of the data that will be kept in the database. These data need to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in Problem 65. RENTAL RENT_NUM RENT_DATE MEM_NUM 1001 01-MAR-13 103 1002 01-MAR-13 105 1003 02-MAR-13 102 1004 02-MAR-13 110 1005 02-MAR-13 111 1006 02-MAR-13 107 1007 02-MAR-13 104 1008 03-MAR-13 105 1009 03-MAR-13 111 VIDEO VID_NUM VID_INDATE MOVIE_NUM 54321 18-JUN-12 1234 54324 18-JUN-12 1234 54325 18-JUN-12 1234 34341 22-JAN-11 1235 34342 22-JAN-11 1235 34366 02-MAR-13 1236 34367 02-MAR-13 1236 34368 02-MAR-13 1236 34369 02-MAR-13 1236 44392 21-OCT-12 1237 44397 21-OCT-12 1237 59237 14-FEB-13 1237 61388 25-JAN-11 1239 61353 28-JAN-10 1245 61354 28-JAN-10 1245 61367 30-JUL-12 1246 61369 30-JUL-12 1246Consider the following structure of an 'inventory' Oracle database. cutomer UMERIC ($) VARCHAN 30 VARCHAR (18 DECIMAL SALESMAND CUSTOMER DNUMERIC (6) NAME CUBT NAME WOR(30 WCHAR (15) CITY aITY COMMISSION GRADE NUMERIC (3) SALESMAN D NUMERIC($) orders ORD NO NUMERIC (5) PURCH AMT DECIMAL (8,2) ORD DATE DATE CUSTOMER ID NUMERIC (5) SALESMAN ID NUMERIC (5) Display all information of those salesmen whose names contain four characters or more, in which the 1st character is always N, while the 4th one is always T. The rest of characters can be anything. For example: 'Nail Knite' is a valid name. Use the editor to format your answerConsider the following structure of an 'inventory Oracle database. cuelomer *** MUMERIC ($) VARCHAR 30) VARCHAR (15 DECIMAL) SALESMANJD NAME CUSTOMER JD ERC ($) CUST NAME RCHAR (30 CHAR (15 MUMERIC (3) CITY CITY COMMISSION GRADE SALESMAN ID NUMERIC ($) orders ORD NO NUMERIC (5) PURCH AMT DECIMAL (8,2) ORD DATE DATE CUSTOMER ID NUMERIC (5) SALESMAN ID NUMERIC (5) Find the highest purchase amount with customer ID of the one who made it, along with the order date; for those customers who have a higher purchase amount in a day within the range 2000 and 6000. Use the editor to format your answer 81
- Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table . 4- display a list of each employee SSN, Name and Salary. 5- display a list of each employee SSN , Name and Salary for employees working in department no 2.Write the DDL statements for declaring the Library relational database schema listed below. Specify the kay (Primary and Foreign where applicable). BOOK Book id Title Publisher name BOOK AUTHORS Bock id Author name PUBLISHER Name Address Phone BOOK COPIES Book d Branch id No ef_oopies BOOK LOANS Book id Branch id Card no Dute out Due date LIBRARY BRANCH Branch id Branch name Addresa BORROWER Card no Name Addre PhoneAccess Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
- The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?Write appropriate SQL DDL statements for declaring the database "Employee", assign admin privilege to user "AMAL" Write appropriate SQL DDL statements for declaring the table PERSONS. Specify all constraints: Field Null key PersonID No PRIMARY No LastName varchar(30) FirstName varchar(30) No Address varchar(50) YES City varchar(30) YES Type intDatabase Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,
- Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr start date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno M WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table. 4- display a list of each employee SSN , Name and Salary. 5- display a list of each employee SSN, Name and Salary for employees working in department no 2.An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) Formulate the following SQL statements: a) Find the names of all the patients being prescribed ‘Morphine’.b) What is the total cost of Morphine supplied to a patient called ‘John Smith’?c) For each ward that admitted more than 10 patients today, list the ward number, ward type and number of beds in each ward.