Reference no: EM133218313
Q - Consider the following universal relation that holds information about the inventory of books in a bookstore.
Books (title, isbn, author, publisherName, publisherAdd, totalCopiesOrdered, copiesInStock, publicationDate, category, sellingPrice, cost)
Assume:
- The isbn uniquely identifies a book. (It does not identify each copy of the book, however.) › A book may have more than one author.
- An author may have more than one book.
- Each publisher name is unique. Each publisher has one unique address- the address of the firm's national headquarters.
- Titles are not unique.
- totalCopiesOrdered is the number of copies of a particular book that the bookstore has ever ordered, while copiesInStock is the number still unsold in the bookstore.
- Each book has only one publication date. A revision of a book is given a new ISBN. - The category may be biography, science fiction, poetry, and so on. The title alone is not sufficient to determine the category.
- The sellingPrice, which is the amount the bookstore charges for a book, is always 20 percent above the cost, which is the amount the bookstore pays the publisher or distributor for the book.
a. Using these assumptions and stating any others you need to make, list all the non-trivial functional dependencies for this relation.
b. What are the candidate keys for this relation? Identify the primary key.
c. Is the relation in third normal form? If not, find a 3NF lossless join decomposition of Books that preserves dependencies.
d. Is the relation or resulting set of relations in Boyce-Codd Normal Form?
|
Admin configured machine
: Another admin configured the machine at 31.202.15.9 as a postfix email server, but users are complaining
|
|
Discuss some of the advantages of the database approach
: Discuss some of the advantages of the database approach. Provide a brief overview of the various components of the database environment
|
|
Display the list of customers
: This project is continuation of "Project One" that you have completed during this course. "Project One" was an open-topic project (Online sale, Hotel, Hospital,
|
|
Change the type of room 301 in building h to office
: You need to submit the MongoDB code and the screenshots of the data (result sets) from the collection.
|
|
Information about the inventory of books in a bookstore
: Q - Consider the following universal relation that holds information about the inventory of books in a bookstore.
|
|
Registration information system is software
: A Registration Information System is software that is used to enter all the information of the students, that include the enrolled courses, grades,
|
|
Describe typical pairs of entities
: Describe some typical pairs of entities that you think might be common in business and describe their relationships: many-to-many, one-to-many, many-to-one, or
|
|
Create records in the table using insert statement
: Part A - Create a schema in mySQL to store sales records for an order.
|
|
Certain wireless network is operating under conditions
: A certain wireless network is operating under the following conditions. The access point radio has a transmit power (Ptx) of 16 dBm and an antenna
|