Assume that the Authors table is already built in the database with the following specifications:Authors:Column NameData TypeconstrainsAuthors IDAuthor NameVarchar2(10)|Varchar2(30)Primary keyUniqueYou Need to Create the Books table with the following specificationsColumn NameData TypeConstrainsISBNBook TitleBook PriceAuthor idNumber (10)Varchar2(40)Number (4,2)Varchar2(10)Primary keyNot Nullreferencing the Author_ID inthe Author TableComplete the create statement by drag and drop the correct word:Create Table lblank (ISBN Number (10) plank,Book Title Varchar2blank ) Not Null,Book Price Number(4, 2),Auther IR blank (10) references Jolank (blank );Author ID Books Number||Authors Not Nul Varchar2| Primary Key 40h (United States)

The query to create Books table is as in next step:

Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name ISBN Book Title Book Price Author id Data Type Constrains Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) blank. Book Title Varchar2(blank) Not Null, Book Price Number(4, 2), Author ID blank (10) references blank (blank )); IAuthor ID Books Number Authors Not Null Varchar2| Primary Key 40

Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name ISBN Book Title Book Price Author id Data Type Constrains Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) blank. Book Title Varchar2(blank) Not Null, Book Price Number(4, 2), Author ID blank (10) references blank (blank )); IAuthor ID Books Number Authors Not Null Varchar2| Primary Key 40

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

Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
What is the purpose of field values being coded?
A USE statement __________ None of these Identifies the database within which the query is to be executed Identifies the SET theory All of these Identifies Mr. Peabody’s rules
Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price moneyWrite a Select statement that returns the Trading_Symbol column only from the rows where Purchase_Price is greater than $25.00.
SQL Database help
Table Name Item Column name Constraint Primary key Datatype Varchar2 Varchar2 Varchar2 Size 6 ID ITEM N AME MANUFACTUR ER 30 PRICE Number Not Null DELIVERY DATE Date Varchar2 STATUS 10 Table Name Customer_ Details Column name ID CUSTOMERNAME Datatype Varchar2 Constraint Foreign Key Size Varchar2 Varchar2 30 30 LOCATION CUSTOMERID Varchar2 Number QUAΝΤΙΤΥ Data for Item table ID ΙTEΜ ΑΜΕ MANUFACTURER PRICE DELIΙVERYΥ DAΤΕ STATUS COMPUTER KEYBO ARD COMP UTER COMPUTER 09001 DELL 35000 12-June-2020 PENDING 09002 INTEX 10000 25-June-2020 PENDING COMPL ETED COMPL ETED COMPL ETED 09003 SAMSUNG 32000 18-Feb-2020 09004 LENOVO 37000 о3-Аргil-2020 0900s LAPTOP DELL 57000 20-May-2020 Data for Customer_ Details table ID CUSTOMERNAME CITY CUSTOMERID C0001 C0002 QUANΤITY 525 09001 KALIFA NIZWA 09002 BARKA 8400 09003 09004 SOHAR C0003 C0001 5250 525 NIZWA 09005 BARKA C0004 3150 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and 37000 . 7. Write an SQL query…
Need help writing SQL queries for sample data base
Access 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…
In a database, Write SQL query to show table structure of table name Guardians.
Database based question
Please insert the data into the database tables
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145