PLZ help with the following: 1. Populate every relation with “sufficient” representative rows (at least 4 for each table). Create table book (title varchar(80) not null, year INT not null , num INT primary key , subject Varchar(50) null); Create table client (CID int primary key,fname varchar(20), lname varchar(20), type varchar(6), constraint checkclient check (type in ('Faculty', 'Student'))); Create table author (year INT, ID INT primary key, fname varchar(50) not null,lname varchar(50)); Create table BookAuthors(booknum int, authorID int, primary key (booknum, authorID), constraint fk_book foreign key (booknum) references book(num), constraint fk_author foreign key (authorid) references author(id)); create table bookcheckouts( booknum int, clientID int, checkoutdate date, expectedDuedate date not null, returnedate date, primary key (booknum, clientID, checkoutDate), constraint book_checks foreign key(booknum) references book(num), constraint book_clients foreign key (clientid) references client(CID));
![Q: [ slide-15 .png ] Q1. Please write SQL codes to create below member database table based on…A: A relational database contains tables. Tables are also known as relations and they contain rows and…](/questions-and-answers/slide-15-.png-q1.-please-write-sql-codes-to-create-below-member-database-table-based-on-the-previous/3b4446fb-5348-4dbb-944d-a99326b9259f){kind=link}
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.
PLZ help with the following:
1. Populate every relation with “sufficient” representative rows (at least 4 for each table).
Create table book (title varchar(80) not null, year INT not null , num INT primary key , subject Varchar(50) null);
Create table client (CID int primary key,fname varchar(20), lname varchar(20), type varchar(6), constraint checkclient check (type in ('Faculty', 'Student')));
Create table author (year INT, ID INT primary key, fname varchar(50) not null,lname varchar(50));
Create table BookAuthors(booknum int, authorID int, primary key (booknum, authorID),
constraint fk_book foreign key (booknum) references book(num),
constraint fk_author foreign key (authorid) references author(id));
create table bookcheckouts( booknum int, clientID int, checkoutdate date, expectedDuedate date not null, returnedate date, primary key (booknum, clientID, checkoutDate),
constraint book_checks foreign key(booknum) references book(num),
constraint book_clients foreign key (clientid) references client(CID));
Step by step
Solved in 2 steps
