EBK CONCEPTS OF DATABASE MANAGEMENT
8th Edition
ISBN: 8220100706004
Author: Last
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 1SCGC
To determine
To determine which data from the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
Note: Use MYSQL
Create a database named book-collection-db and table named: bookcollect. Your tableshould contain the following columns: Title, Author, Genre (Children’s, Romance,Thriller, Fantasy, etc.), Publisher, Copyright Date, ISBN Number, Category (Fiction/Nonfiction), Overview, Link Where to Buy, and Price. Create 30 rows containing list of bookwith varied genre.
Design a survey form of your own. Fill it out as it might have been completed during the database design for Henry Books. For any questions you have too little information to answer, make a reasonable guess.
(Ray Henry, the owner of a bookstore chain named Henry Books, gathers and organizes information about branches, publishers, authors, and books. Each local branch of the bookstore has a number that uniquely identifies the branch. In addition, Ray tracks the branch’s name, location, and number of employees. Each publisher has a code that uniquely identifies the publisher. In addition, Ray tracks the publisher’s name and city. The only user of the Book database is Ray, but you do not want to treat the entire project as a single user view. Ray has provided you with all the reports the system must produce, and you will treat each report as a user view. Ray has given you the following requirements:
User View 1 Requirements: For each publisher, list the publisher code, publisher name, and…
Chapter 8 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
Ch. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQCh. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - Prob. 10RQ
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Prob. 14RQCh. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - Prob. 17RQCh. 8 - Prob. 18RQCh. 8 - Prob. 19RQCh. 8 - Prob. 20RQCh. 8 - Prob. 1TDECh. 8 - Prob. 2TDECh. 8 - Prob. 3TDECh. 8 - Prob. 4TDECh. 8 - Prob. 1CATCCh. 8 - Prob. 2CATCCh. 8 - Prob. 3CATCCh. 8 - Prob. 4CATCCh. 8 - Prob. 1SCGCCh. 8 - Prob. 2SCGCCh. 8 - Prob. 3SCGCCh. 8 - Prob. 4SCGC
Knowledge Booster
Similar questions
- Assignment Connectivity Practical : Create the table given below in database named Sports and insert all 5 records Table : CLUB COACH-ID COACHNAME AGE SPORTS DATOFAPP PAY SEX 1. KUKREJA 35 KARATE 27/03/1996 1000 M 2. RAVINA 34 KARATE 20/01/1998 1200 F 3. KARAN 34 SQUASH 19/02/1998 2000 M 4. TARUN 33 BASKETBALL 01/01/1998 1500 M 5. ZUBIN 36 SWIMMING 12/01/1998 750 M Write a menu driven program in python to perform the following operations, the program should run till the exit option is not selected. 1) Add new CLUB 2) Delete an existing CLUB 3) Modify / Update values of an existing CLUB 4) Search for the specified options :- i) ii) ii) 5) Display all records Search by Coach ID Search by Coach Name Search by Sports 6) Exit Each menu option is implemented by user defined functions defined in a module named Sports.arrow_forwardThe manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in the table below.Table: Sample CLIENT records Attribute name Sample value Sample value Sample value CLIENT_NUM 298 289 289 CLIENT_NAME Marianne R. Brown James D. Smith James D. Smith CLIENT_REGION Midwest Southeast Southeast CONTRACT_DATE 10-Feb-2018 15-Feb-2018 12-Mar-2018 CONTRACT_NUMBER 5841 5842 5843 CONTRACT_AMOUNT R22,985,00.00 R1,670,300.00 R11,250,000.00 CONSULT_CLASS_1 Database administration Internet services Database design CONSULT_CLASS_2 Web applications Database administration CONSULT_CLASS_3 Network installation CONSULT_CLASS_4 CONSULTANT_NUM_1 29 34 25 CONSULTANT_NAME_1 Rachel G. Carson Gerald K. Ricardo Angela M. Jamison CONSULTANT_REGION_1 Midwest Southeast Southeast CONSULTANT_NUM_2 56 38 34 CONSULTANT_NAME_2 Karl M. Spenser Anne T. Zuma Gerald K. Jele CONSULTANT_REGION_2 Midwest Southeast Southeast CONSULTANT_NUM_3 22 45 CONSULTANT_NAME_3 Julian H.…arrow_forward.Considered the tables structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named “Invalid credit”. Display the result of the average as integer.arrow_forward
- Using MySQL, design a 2 table database. The data types of columns should be set properly tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month) The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordingly Using Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons. 1.4 The first button will open aa frame that can be used to add, update and delete Gyjm Members. The second button will open a frame that will be used to collect the payments made by students. 1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example: Order # is the sequence number of the member in tblMembers…arrow_forwardThe following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100arrow_forwardas a database you need to ensure that each excercise log has a unique ID number, date, excercise category, excercise subcategory, time spent, calories burnt . each customer has unique cust_number and their first name, last name, address, program number, program tile and payment must be recorder. every program has a program number(PNum) that uniquely identifies the program. the program title, startDate, FinishDate, price must also be recorder. each coach has unique Id number. their first name, last name, date of birth, address, contactNo, username and password must be recorder. A coach can work on only one program. A program can have one or more coaches associate with it. one customer can enroll for one program at a time. normalize the above database in 3NF. State for every step in normalization which functional dependency cause it. identify different type of anomalies which can be found in a database. how can we overcome them ?arrow_forward
- Joan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. She has determined that she needs the following tables and fields in her database:(Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip Code, Social Security Number, Phone Number, Hourly Pay Rate, and Project Number (Table 2) Project Information:Fields - Project Number, Project Name, Project Leader, Project Location, Total Hours, and Actual Completion Date What data type should Joan Yancey use for the Actual Completion Date field and why?arrow_forwardConsidered the tables structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named "Invalid credit". Display the result of the average as integer. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BI U S Paragraph A v In x X2 Arial 10pt ...arrow_forwardFor table EP, the attribute is a foreign key referencing target table For table EP, the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target table For table ER the attribute is a foreign key referencing target tablearrow_forward
- Create the Database Schema, the Normalize table, and the Final ERD StudentID Name Age Course CourseName Room ProfessorID Professor 1 Michael |17 СОЕО01 Computer Fundamentals O01 201201 Nath COEO02 Computer Programming 020 201202 Butch COEO03 Computer Design 300 201201 Nath 2 Jane 18 СОЕО01 Computer Fundamentals 001 201201 Nath COEO02 Computer Programming 020 201202 Butch 3 Max |17 СОЕО01 Computer Fundamentals 001 201201 Nath COEO03 Computer Design 300 201201 Nath Step by step procedure of Normalizationarrow_forwardQ2 Create a Database with at least 4 tables, 3 queries, 2 forms, and 1 report. Each table should have at least 10 records. for library designarrow_forwardUsing MongoDb do the following activities Create database named First. Create a collection named dbase6211 Insert 5 records guided by the following titles. -ProductID -ProductName -Product expiry date -Reorder level Display all the 5 records.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr