appropriately. Table: Author Column Name Data Type Size/Length Constraint Type AID Number Primary Key AName Varchar2 Not Null Lang Varchar2 Phno Number Table: Book Column Name BID Bname Publisher Rate Tax AID Data Type Varchar2 10 Varchar2 25 Varchar2 25 Number 5,2 3 Number Number 20 50 8 Size/Length Unique Constraint Type Primary Key Not Null Constraint Name Assign a proper name Foreign Key Constraint Name Between 1 and 200 Assign a proper name Assign a proper name
appropriately. Table: Author Column Name Data Type Size/Length Constraint Type AID Number Primary Key AName Varchar2 Not Null Lang Varchar2 Phno Number Table: Book Column Name BID Bname Publisher Rate Tax AID Data Type Varchar2 10 Varchar2 25 Varchar2 25 Number 5,2 3 Number Number 20 50 8 Size/Length Unique Constraint Type Primary Key Not Null Constraint Name Assign a proper name Foreign Key Constraint Name Between 1 and 200 Assign a proper name Assign a proper name
Chapter4: Constraints
Section: Chapter Questions
Problem 1MC
Related questions
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
Transcribed Image Text:appropriately.
Table: Author
Column Name Data Type Size/Length Constraint Type
AID
Number
Primary Key
Varchar2
Not Null
Varchar2
Number
AName
Lang
Phno
Table: Book
Create all the below tables using SQL queries with necessary key constraints
Column Name
BID
Bname
Publisher
Rate
Tax
AID
AID
311
312
Table: Author
313
314
315
316
Table: Book
B07
B08
Data Type
Varchar2
10
Varchar2 25
Varchar2
25
Number
5,2
Number 3
Number
AName
Amira
Saif
Meera
Hani
Ahmed
Marwan
BID
Bname
B01
Palace of Desire
B02
Rainbow Fish
B03
King and Lion
B04 Ghost Village
B05
The Truth
B06
Peter Pan
20
50
8
The Last Leaf
The Little
Size/Length
Insert all the values to the tables using SQL queries.
Lang
Arabic
Unique
English
Hindi
Arabic
English
English
Constraint Type
Primary Key
Not Null
Foreign Key
Between 1 and 200 Assign a proper name
Assign a proper name
Phno
99455625
99456625
99457725
97795234
97795254
97795354
Publisher Rate
Tata
160
Pearson
140
DC Books
120
Pearson
Tata
Pearson
DC Books
Tata
180
170
140
130
175
Tax
10
5
5
10
15
Constraint Name
Assign a proper name
10
10
5
Constraint Name
AID
314
312
315
313
316
314
315
316
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
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.Recommended textbooks for you
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
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
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage