Homework Answers
Add Answer to:
Question: Consider the following relation for published books: BOOK (Book title, Author_name, Book_type, List_price, Author_affil, Publisher)...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil,...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
need help with question 5. 3- Consider the following relation for published books: BOOK(Book_ title, Author_name,...
need help with question 5.
3- Consider the following relation for published books: BOOK(Book_ title, Author_name, Book_type, List_price, Author_affil, Publisher) Suppose the following dependencies exist: Book_title à Publisher, Book_type Book_type à List_price Author_name à Author_affil a. What normal form is the relation in? Explain your answer? b. Apply normalization until you cannot decompose the relation further. State the reasons behind the decomposition. 4- Consider the above question, write a program in python to create xml file for the decomposed BOOK...
1. Consider a Relation that holds attributes of courses and sections at a university: R =...
1. Consider a Relation that holds attributes of courses and sections at a university: R = CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN, Semester, Year, Days Hours, RoomNo, NoOfStudents Assume that the following functional dependencies hold: • CourseNo → Offering Dept, CreditHours, CourseLevel • CourseNo, SecNo, Semester, Year → Days Hours, RoomNo, NoOfStudents, InstructorSSN • RoomNo, Days Hours, Semester, Year → InstructorSSN, CourseNo, SecNo Normalize Relation R upto 3NF. 2. Consider the relation for published books: Book = Book title, AuthorName,...
Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city) Given the following relation,...
Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city)
Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city)
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher,...
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...
Write a C program to create a list of books details. The details of a book...
Write a C program to create a list of books details. The details of a book include title, author, publisher, publishing year, no. of pages , price Perform the following with respect to the list of books created Display all the details of books written by a given author. Sort the details of books in the increasing order of price. Display the details of books published by a given publisher in a given year. Sort the list of books in...
Consider the following table schemas (primary keys are underlined): Book (BookId, Title, Publishername) Book_Authors (BookId, AuthorName) Publisher...
Consider the following table schemas (primary keys are underlined): Book (BookId, Title, Publishername) Book_Authors (BookId, AuthorName) Publisher (Name, Address, Phone) Book_Copies (BookId, BranchId, No_Of_Copies) Book_Loans (BookId, BranchId, CardNo, DateOut, DueDate) Library_Branch (BranchId, BranchName, Address) Borrower (CardNo, Name, Address, Phone) Write SQL statements for the following queries: List the number of copies of the book titled “The Lost Tribe” owned by each library branch and the corresponding library branch name. List the names and addresses of all borrowers who have borrowed more than 5 books...
Author(name, address, URL) Book(ISBN, title, year, price, publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL)...
Author(name, address, URL)
Book(ISBN, title, year, price,
publisher_Name)
WrittenBy(name, address, ISBN)
Publisher(name, address, phone, URL)
Warehouse(code, phone, address)
Stocks(ISBN, WH_code, number)
Shopping-Basket(basketID, email)
basketContains(ISBN, basketID, number)
Customer(email, name, address, phone)
Referring to the relational model in slide 15 in"ER-mapping" (about author, publisher, shopping-basket, provide the algebraic pressing for the following queries Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is Mark Smith" Q2: For each customer,...
Consider an ABC digital library that manages technical books, the data requirements are summarized as follows:...
Consider an ABC digital library that manages technical books, the data requirements are summarized as follows: A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. A book is written by one or multiple authors. Each author is identified by...
Write just one SQL statement per question 1. Display Publisher ID, Publisher Name and Total Number...
Write just one SQL statement per question 1. Display Publisher ID, Publisher Name and Total Number of Books published by each publisher. 2. List Publisher ID, Publisher Name, Title and price of the highest priced book. 3. List Order ID, Customer ID, Order Date, and Number of Items in each order. Order the data by Customer ID in ascending (A – Z) order. 4. Display Title, Category and Profit for each book in the children and computer category. 5. Display...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
need help with question 5.
3- Consider the following relation for published books: BOOK(Book_ title, Author_name, Book_type, List_price, Author_affil, Publisher) Suppose the following dependencies exist: Book_title à Publisher, Book_type Book_type à List_price Author_name à Author_affil a. What normal form is the relation in? Explain your answer? b. Apply normalization until you cannot decompose the relation further. State the reasons behind the decomposition. 4- Consider the above question, write a program in python to create xml file for the decomposed BOOK...
Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city)
Given the following relation, what are potential Multivalued Dependencies (MVDs)? title, author, number_pages, publisher) author-(name, age) publisher (name, city)
Consider the following relation tables (fields with underline is primary keys): Author(Name, Country) Book(ISBN, Title, Publisher, Subject) Writes(Name, ISBN) Write the relational algebra for the following query: a. (2 points) Give the titles of all books with "Art" subject Solution: b. (2 points) Give the name of all authors who publish with "Harding" Solution: (2 points) Give the name of all authors who have written books with "Science" subject Solution: c. d. (3 points) Give the titles of all books...
Author(name, address, URL)
Book(ISBN, title, year, price,
publisher_Name)
WrittenBy(name, address, ISBN)
Publisher(name, address, phone, URL)
Warehouse(code, phone, address)
Stocks(ISBN, WH_code, number)
Shopping-Basket(basketID, email)
basketContains(ISBN, basketID, number)
Customer(email, name, address, phone)
Referring to the relational model in slide 15 in"ER-mapping" (about author, publisher, shopping-basket, provide the algebraic pressing for the following queries Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is Mark Smith" Q2: For each customer,...
Most questions answered within 3 hours.
-
Calculate the pH of each of the following solutions.
0.50 M HBr
3.1×10−4 M KOH
4.2×10−5...
asked 1 hour ago -
For the year ended December 31, Depot Max’s cost of merchandise
sold was $85,600. Inventory at the...
asked 1 hour ago -
Week 10 - Professional Memo Assignment
Professional Memo Assignment
Your mission for this week, should you...
asked 2 hours ago -
Write a Python program that stores the data for each
player on the team, and it...
asked 2 hours ago -
In
the last 3 months, mike never knows when he is going to get his
allowance...
asked 2 hours ago -
Is Ca(OH)2 a Bronsted base, Lewis base, or both? Why?
asked 2 hours ago -
1A- Why don’t voters complain about U.S. tariffs on imported
sugar?
Because sugar is only a...
asked 2 hours ago -
Cash Payback Period
Primera Banco is evaluating two capital investment proposals for
a drive-up ATM kiosk,...
asked 2 hours ago -
Create a button in Swift (Xcode) that will create a charge,
create a charge using Stripe's...
asked 2 hours ago -
The reaction rate of CO and NO2 in the reaction
CO(g) + NO2(g) → CO2(g) +...
asked 2 hours ago -
Imagine that a chemist puts 6.40 mol each of
C3H8 and O2 in a 1.00-L container...
asked 2 hours ago -
How much money should be invested today in order to have $8340
at the end of...
asked 2 hours ago