Consider the following structure of an inventory Oracle database.omancutomerMMERIC ($)wRCHAR 30)VARCHAR(16DECMAL2)SALESMANLIDCUETOMERDMERC($)CUST JAMENAMEMCHAR(30CITYCOMMISSIONVARCHAR (1NUMERIC (3)CITYORADESALESMAN D ERC ($)ordersORD NOPURCH AMTNUMERIC (5)DECIMAL (8.2)ORD DATEDATECUSTOMER ID NUMERIC (5)00SALESMAN ID NUMERIC (5)Write the code to List the names of salesmen who are from the city of Paris.Use the editor to format your answer81

Where clause is used to put condition check.

Consider the following struCtu Orade database. selneman eutomer MUMERIO ($) VARCHAR 30) ARCHAR (161 DECMAL) PUSTOMERJDAERC() WOHAR () VARCHAR (S MMERC (3) SALESMANDMERIC (5) BALESMANJD NAME CUST NAME CITY COMMISSION cTY ORADE orders ORD NO PURCH AMT ORD DATE CUSTOMER ID NUMERIC (S) SALESMAN 0 NUMERIC (5) NUMERIC (5) DECIMAL (2) DATE Write the code to List the names of salesmen who are from the city of Paris. Use the editor to format your answer

Consider the following struCtu Orade database. selneman eutomer MUMERIO ($) VARCHAR 30) ARCHAR (161 DECMAL) PUSTOMERJDAERC() WOHAR () VARCHAR (S MMERC (3) SALESMANDMERIC (5) BALESMANJD NAME CUST NAME CITY COMMISSION cTY ORADE orders ORD NO PURCH AMT ORD DATE CUSTOMER ID NUMERIC (S) SALESMAN 0 NUMERIC (5) NUMERIC (5) DECIMAL (2) DATE Write the code to List the names of salesmen who are from the city of Paris. Use the editor to format your answer

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

Create the table that would result from Tstu_code, dept_code (student a professor). FIGURE Q3.8 THE CH03_COLLEGEQUE DATABASE TABLES Database name: Ch03_CollegeQue Table name: STUDENT STU CODE PROF_CODE 100278 128569 2 512272 4 531235 2 531268 553427 1 Table name: PROFESSOR PROF CODE DEPT CODE 12 26 36 44 To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the file name. (Example: ch3_review1_Jones.doc)
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
We want to maintain a database for a Faculty within a multi-campus regional university. The facultyhas a number of schools and each school is characterized by its school-code which is unique, nameand campus location. Schools employ professors who are characterized by their unique staff-id, nameand the school they work for. A school offers courses that are characterized by their course-code whichis unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll intocourses that are characterized by student-id which is unique, name, address and phone. The following business rules apply• A course must belong to only one school, but a school may have many courses• A student must be enrolled in a course, but a course may have 0 or more students• A course must have one or more subjects, but a subject may be taught as part of many courses• A student may be enrolled in…
Consider the following Books database which is used to keep track of books and their readers. Assume that the database is composed of the following three relations where the key attributes are underlined. BOOK Title PERSON READS PID 111 111 222 333 444 BID PID 111 Gender BookID StartDate 2/4/2015 PYear Price Name 2 Internet programming Database System Programmin g using C++ 1 2016 50 Sami M 3 2/6/2015 8/4/2017 Khawla Rawan Zainab Khamis 222 2 2013 45 4 333 444 2 2/6/2015 3 2011 25 555 M 2 2/4/1995 444 1 2/8/1995 Operating Systems Oracle DBMS 4 2009 35 5 2017 50 • Write a SQL query to display the information including title, name (person name), and PID of all the books which have been read (StartDate) in the year 2015, and the price of these books is less than 50. Convert the generated SQL query into a Relational algebra query. Then, draw the optimized query tree (fifth step of query optimization). Note: You can draw a tree on a paper, scan, and upload in the Moodle OR you can describe…
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
If you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…
Your job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.
The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…
Create the following tables in your database with the following schema: Table: Employee | Column Name | Type | empId I name | supervisor | salary | int | varchar | | int | int empId is the primary key column for this table. Each row of this table indicates the name and the ID of an employee in addition to their salary and the id of their manager. Table: Bonus | Column Name | Type | | empId | bonus | int | int empId is the primary key column for this table. empId is a foreign key to empId from the Employee table. Each row of this table contains the id of an employee and their respective bonus. Add the following data to your tables: Input: Employee table: | empId | name | supervisor | salary | | 3 | Brad | null | 4000 | 1000 | 2000 | 4000 | John | 3 | 2 | 4 | Dan | 3 | Thomas | 3
Giving the following schema for a supermarket database, specify the domain constrains for each attribute. CUSTOMERS (CustomerID , First_Name, Last_Name) EMPLOYEES (EmployeeID, Name, Email, PhoneNo) INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
laddress q1) normalize the following database Payment Payment_id Member_id Payment_date Amount Payment_time Member_id SSN Equipment serial_num model_num equipment_type availability equipment_price Member_id 1SSN (FK) (FK) Member Member_id SSN date_joined Fname Mname Member_Class No. Member_id ISSN Class_id Membership Lname age MS id MS_level MS price DOJ expiry_date (FK) Email phone MS_id (FK) (FK) Staff_id (FK) SSN Staff Staff_id SSN DOJ Fname Mname SSN JO Class_id Instructor_Class No. Staff id (FK) Class (FK) Lname Jage laddress Email phone Manger_id Manger_SSN Class id cost class_date class_type class_time class_duration class_size Instructor Staff id SSN Specialty Certifications (FK) (FK)