A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale O The average price of a computer was sold by the retailer In which months less than 100 computers were sold

A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale O The average price of a computer was sold by the retailer In which months less than 100 computers were sold

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

Related questions

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: eans that: Question 4 options: Not only SQL is us

A: Accessing Data with NoSQL Means that: Question 4 options: Not only SQL is used Only SQL is used No…

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: ts: You will need to add data to both tables. Remember that the movie table has th duction co., not…

A: Description: 1- If a user wants to insert records one by one then needs to use the following…

Q: Make a list of how many albums each artist has released. Only include artists with more than 5…

A: To create a list of artists with more than 5 albums, we need to query the database tables and count…

Q: g Make sure to use oracle sql command and add foreign keys The faculty and students (we refer to…

A: The given requirements are related to the creation of data model using details provided for the…

Q: Write an SQL statement to list LastName and FirstName of customers who have purchase an item that…

A: we need to write Write an SQL statement to list LastName and FirstName of customers who have…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Explain when you would prefer to use embedded SQL over SQL or a general-purpose programming…

A: Embedded SQL is a technique that allows SQL statements to be integrated directly into a…

Q: Which of the following attributes would most likely be a primary key in one of the tables of a…

A: D and E

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber) The partial functional dependency…

Q: Using database, show the first name and birthday for all female staff whose birthday is before…

A: Introduction: The AND, OR, and NOT operators can be used with the WHERE clause. Records can be…

Q: Create the Student table with following details: Data type Number Varchar(25) Field Constraint Sid…

A: We are assuming that the field book_id references a table by name of Book which has book_id as its…

Q: Given two database table i_users(userid,username,email address,isActive,gender) stores the users…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: Write the relational schema for UNF, 1NF, 2NF and 3NF for this table.

A: PETID PETNAME PETTYPE PETAGE OWNER VISITDATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN…

Q: 1. How many reviews for every product?

A: Let us suppose that the table is created as given below: create database DB; use DB; create table…

Q: Using SQL Show the distinct location_id for all the locations where the company has departments

A: SQL SQL stands for Structured Query Language, and it is a programming language used to store,…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary, Job_id FROM employees WHERE EXISTS (SELECT *…

Q: Show the total number of reviews of most liked product per retailer in every city Here is the…

A: The details about the table are given with table name and different entities. Here the table name is…

Q: Use SQL and TAL Distributors database to complete the following questions: List the customer…

A: SELECT statement :- It is used to retrieve information from the table or database. The syntax for…

Q: Design a database for this data.

Q: Write an SQL statement to list the LastName and FirstName of customers who have made at least one…

A: Given that, Write an SQL statement to list the LastName and FirstName of customers who have made at…

Q: How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and…

A: Count Query :- SELECT COUNT(column_name) FROM table_name WHERE condition; Groupby Query :-…

Q: Explain when you would use embedded SQL as opposed to standard SQL or a general-purpose programming…

A: Introduction: As a result, SQL may be integrated into a programming language, allowing the host…

Q: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Q: student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno,…

A: We need to write the SQL query for the given schema to print the name(s) and sid(s) of the…

Question

A retailer of computers maintains a record containing the following information for every individual
computer sold.
• Manufacturer name
• Model number
• Physical memory size
• Processor name
• Date of sale
• Price sold for
Using only the database, which of the following CANNOT be determined?
The most popular model of computer sold by the retailer
Which models of computer stocked by the retailer have not had a single sale
The average price of a computer was sold by the retailer
In which months less than 100 computers were sold

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

please fast its database
From the database scheme write the query(all tables are empty) 1) Insert your name and your phone as a new tenant 2) Delete your phone number from the table tenant. 3) Create a new contract lease for you. 4) Delete the contract that you created. 5) List the city name, city population and country name. 6) List the cities that have the letters “re” in any part of the name; 7) List the tenant name contract number, rent price, when the contract rent price is bigger equal 500 and lower equal 1000. 8) List all columns from apartments with the services offered (all columns from service). 9) List the building address, the city name and the country name for the building in Canada. 10) List the name of the user with the city name and country name, ordering by name of user.
Tables: department, dept_emp, dept_manager, employees, salaries, titles department (columns): dept_no, dept_name dept_emp (columns): emp_no, dept_no, from_date, to_date dept_manager (columns): emp_no, dept_no, from_date, to_date employees (columns): emp_no, birth_date, first_name, Last_name, gender, hire_date salaries (columns): emp_no, salary, from_date, to_date titles (columns): emp_no, title, from_date, to_date a) Your task is to write a SQL query to find count of employee who does not have a manager in the above given table schema?
Add the provided information to a new record in the REP table. SELECT * FROM REP Expected Results REP_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL_PHONE COMMISSION RATE 35 Fred Kiser 427 Billings Dr. Cody WY 82414 307-555-6309 0.00 0.05
By using this table answer this question in SQL: Show the department id, department name and the number of employees working in any department which has less than 4 employees
A SQL Data Manipulation command like UPDATE or INSERT immediately saves the result to disk without further intervention from the user. Question 31 options: 1) True 2) False
You will be using the Colonial Adventure Tours database. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?
Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)
Explain when you would use embedded SQL as opposed to standard SQL or a general-purpose programming language.
Display manager ID and number of employees managed bythe manager. using sql plus hr user
Input table into sql workbench
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.