SQL Test questions will be based on the assessment_1b_db database. It is a simplified database of a university library database. See the steps below the ERD diagram to install the database.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
icon
Related questions
icon
Concept explainers
Question

Alert dont submit AI generated answer.

SQL Test questions will be based on the assessment_1b_db database. It is a simplified database of a university library database. See the steps below the ERD diagram to install the database.

4
T
bo
E
E
Dri
X
23-B-CP5633-BNE-INT-TR3 Database Modelling
Database for SQL Test - set this up before taking the test
SQL Test questions will be based on the assessment_1b_db database. It is a simplified database of a university library
database. See the steps below the ERD diagram to install the database.
Cat
cat_id INT
cat_name VARCHAR(2)
Indexes
#
Indexes
Publisher
publisher_id INT
publisher_name VARCHAR(50)
publisher_url VARCHAR(50)
publisher_email VARCHAR(50)
Book
bookid INT
book isbn VARCHAR(20)
book title VARCHAR(100)
book shelf_letter VARCHAR(2)
book call_number VARCHAR(3)
book_no_of_pages INT
book_no_of_copies INT
book_date_arrived DATE
publisher_id INT
cat_id INT
. Cat: Category.
Indexes
Loan
loan_id INT
loan_date_out DATE
loan date_due DATE
loan_date returned DATE
borrower_id INT
copy_id INT
Indexes
Copies
copy_id INT
- copy_number INT
book_id INT
Indexes
Borrower
borrower_id INT
borrower_fname VARCHAR(50)
borrower_Iname VARCHAR(50)
borrower_email VARCHAR(50)
borrower phone VARCHAR(20)
Hborrower_street VARCHAR(50)
borrower_suburb VARCHAR(50)
borrower_postcode VARCHAR(4)
borrower_type VARCHAR(1)
date registered DATE
borrower_dob DATE
Indexes
A
3
Transcribed Image Text:4 T bo E E Dri X 23-B-CP5633-BNE-INT-TR3 Database Modelling Database for SQL Test - set this up before taking the test SQL Test questions will be based on the assessment_1b_db database. It is a simplified database of a university library database. See the steps below the ERD diagram to install the database. Cat cat_id INT cat_name VARCHAR(2) Indexes # Indexes Publisher publisher_id INT publisher_name VARCHAR(50) publisher_url VARCHAR(50) publisher_email VARCHAR(50) Book bookid INT book isbn VARCHAR(20) book title VARCHAR(100) book shelf_letter VARCHAR(2) book call_number VARCHAR(3) book_no_of_pages INT book_no_of_copies INT book_date_arrived DATE publisher_id INT cat_id INT . Cat: Category. Indexes Loan loan_id INT loan_date_out DATE loan date_due DATE loan_date returned DATE borrower_id INT copy_id INT Indexes Copies copy_id INT - copy_number INT book_id INT Indexes Borrower borrower_id INT borrower_fname VARCHAR(50) borrower_Iname VARCHAR(50) borrower_email VARCHAR(50) borrower phone VARCHAR(20) Hborrower_street VARCHAR(50) borrower_suburb VARCHAR(50) borrower_postcode VARCHAR(4) borrower_type VARCHAR(1) date registered DATE borrower_dob DATE Indexes A 3
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Query Syntax
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage