PK productIDFK categoryIDnameProductdescriptionpriceWhich tables are lookup tables?CategoryO PhoneType, AddressTypeProductCategoryCustomer, CategoryPK productIDFK categoryIDCategoryPK categoryIDCategory, AddressType, PhoneTypename Review the sample eCommerce ERD after 3NF.PK credit CardIDFK customerIDCredit Cardcredit CardNumberexpDateCCVPK orderIDFK customerIDFK billingAddressIDFK shippingAddressIDFK creditCardIDOrderorder Dateorder TotalOrderLinePK orderLineIDFK orderIDFK productIDquantityunitPrice90°FSunnynamaPK productIDFK categoryIDProductPK customerIDfirstNamelastNameuserNamepasswordCustomerPK addressIDFK customerIDFK addressTypeIDcityaddressaddress2stateAddresszipcountryProductCategoryPK productIDFK categoryIDPhoneTypePK phoneTypeIDnamePhonePK phonelDFK phoneTypeIDFK customerIDphoneNumbernameAddress TypePK addressTypeIDQ

What is a Lookup table?: => An array or matrix of data that includes items that are…

Answered: Which tables are lookup tables?…

Engineering

Computer Science

Which tables are lookup tables? Category Category, AddressType, PhoneType PhoneType, AddressType Customer, Category

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: How to create multiple primary keys? Create multiple primary keys for below table…

A: A primary key is a column or combination of columns in a table that uniquely identifies each row in…

Q: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: am including the previous query, Do i revise a query? 13. Display the total number of flights that…

A: the solution is an given below :

Q: 5. Display the employee ID, last name, first name, start date, end date, and the department id from…

A: Given problem in number 5: Display the employee ID, last name, first name, start date, end date, and…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: If multiple tables are joined together, you can select columns from specific tables by specifying…

A: In SQL, you can apply Join on multiple tables . Join is basically joining two or more tables using a…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Display the CID, CName, and RType from both tables using the CROSS JOIN clause.

A: The main idea of the CROSS JOIN is that it returns the Cartesian product of the joined tables. The…

Q: Using OrcalTal Show all item num and item descriptions from the item table, and a matching num…

A: Answer: Oracle table query: create table items(itemno int not null primary key,itemdesc…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: When must you define constraints at the table level rather than the column level? ( refer to the…

Q: How to create a table in SQL?

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: Write a select statement for the following: Tables sec1313_words1 and sec1313_words2 contains…

A: Question from Mysql:

Q: Display the CID, CName, RID and RType from both tables using the NATURAL JOIN clause.

A: The SQL NATURAL JOIN is a type of EQUI JOIN and is structured in such a way that, columns with the…

Q: Create a table with emp name. emp_no , emp_name , emp_grade , emp_salary , dept_no ,…

A: SQL query: creating table SQL> CREATE table emp 2 ( 3 emp_no NUMBER, 4 emp_name…

Q: Create a new table, named Senior Teaching Staff, using the existing teacher table as your source.…

A: Structured query language is a programming language for storing and processing information in a…

Q: The data set can contain many data tables Select one: True OFalse

A: A data set is an accumulation of linked, separate, tabularly presented related data items that can…

Q: The number of times the table structure has been altered by SQL queries. Which major changes need to…

A: Yes, by tracking modifications in the history table and using SQL commands, you can keep a record of…

Q: How many SQL queries change the structure of the table? Which significant alterations must to be…

A: The answer is given below

Q: Create Department table Create table department with given columns Department department_id number…

A: In the above listed we have to create a table named department with the given table schema. Note as…

Q: How many different SQL queries do you think changed the table's structure? Which substantial…

A: The answer is given below step.

Q: How do we decide which sample table to use as a starting point when creating new tables in Microsoft…

A: When creating new tables in Microsoft Access, it is essential to select an appropriate sample table…

Q: Add a WHERE clause that joins the Reservation table and the Parent table. The common field in both…

A: syntax--> SELECT column1, column2....columnNFROM table_nameWHERE CONDITION;

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: What are joins and mention different types of joins?

A: Joins in SQL are used to combine two or more tables with common fields between them. there are 4…

Q: How is the number of columns in a Web table determined? What adjustment do you have to make when a…

A: Explanation: Table property allow the web developers to present the data in rows and columns…

Q: What will be the field size for the ProductLineName field in the Product table? Why?

A: The field size is 40.

Q: Can you write 10 query for this tables? Plase use join and nested queries Customer…

A: I give 10 queries

Q: Create a table named Clerks, with 3 columns (employee-id, first name and job_id) where all employees…

A: The question has been answered in step2

Q: The 'customer' table contains ten columns but no row. The table is then updated with 10 new rows and…

A: Start: The term "table" refers to a collection of connected data that is recorded in a database in a…

Q: eference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT…

A: SOLUTION - (1) Query - UPDATE NONCATSET PRICE = (PRICE * 1.05)WHERE CATEGORY='BRD'; This query is…

Q: The 'customer' table contains ten columns but no rows. The table is then updated with 10 new rows…

A: Degree of a table in SQL: The number of attributes or columns in a relation is referred to as the…

Q: False

A: EXPLANATION A view in a database is nothing but a virtual table. A view can have rows and columns…

Q: How many SQL alter table structure? Which major adjustments should be considered? These changes need…

A: A table structure contains information on the names of the fields, their sizes, and the data types.…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

100%

PK productID
FK categoryID
name
Product
description
price
Which tables are lookup tables?
Category
O PhoneType, AddressType
ProductCategory
Customer, Category
PK productID
FK categoryID
Category
PK categoryID
Category, AddressType, PhoneType
name

Review the sample eCommerce ERD after 3NF.
PK credit CardID
FK customerID
Credit Card
credit CardNumber
expDate
CCV
PK orderID
FK customerID
FK billingAddressID
FK shippingAddressID
FK creditCardID
Order
order Date
order Total
OrderLine
PK orderLineID
FK orderID
FK productID
quantity
unitPrice
90°F
Sunny
nama
PK productID
FK categoryID
Product
PK customerID
firstName
lastName
userName
password
Customer
PK addressID
FK customerID
FK addressTypeID
city
address
address2
state
Address
zip
country
ProductCategory
PK productID
FK categoryID
PhoneType
PK phoneTypeID
name
Phone
PK phonelD
FK phoneTypeID
FK customerID
phoneNumber
name
Address Type
PK addressTypeID
Q

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

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 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

Which statement must precede a SHOW TABLES statement to see the tables from the bikeStore database? SHOW DATABASES; USE bikeStore; SHOW COLUMNS FROM bikeStore;
-- 1 - Write a view to show all data from Sales.Sales Person table
Find??
Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number 8 PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number Bedroom Number 5 Room Status Varchar2 10 REFERENCES to CID in Clients Table CID Number
Please give me correct solution.
What exactly is the issue with altering the name of a table?
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
plz help with the following: When joining three or more tables, you need to specify a join condition for one pair of tables. Select one: a. True b. False
Please match the keyword or operator from the list below to its correct SQL explanation and syntax in the table. Replace ? with a correct option from the following list: Right outer join, UNION, Left outer join, Cartesian product, Inner join, Full outer join Keyword/Operator Explanation Syntax ? Combine tables vertically SELECT * FROM <table 1> UNION SELECT * FROM <table 2>; ? Produces all possible combinations of rows from the two tables SELECT * FROM <table name 1>, <table name 2>; ? Only matching rows are returned SELECT * FROM <table name 1>, <table name 2> WHERE <join condition> <AND other conditions> <other CLAUSES>; SELECT * FROM <table name 1> INNER JOIN <table name 2> ON join-condition <other clauses>; ? Includes all rows from the left table and inserts NA for non-matching rows SELECT * FROM <table name 1> LEFT JOIN <table name 2> ON <join…
what is table ?
How do we join multiple tables in a SELECT statement? Give an example.
How many rows after inner join, left join, right join, cross join table 1 to table 2? Table1 Column A A B C B A B B Table2 Column B A B D A 0 0 Y