![baileysosmart](/avatars/38556.jpg)
baileysosmart
22.02.2021 •
Computers and Technology
For each of the descriptions below perform the following tasks:
a- 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.
b- A book (see 2 a) is written by one or multiple authors. Each author is identified by an author number and has a name and a date of birth. Each author has either one or multiple books. In addition, occasionally data are needed regarding prospective authors who have not yet published any books.
c- in the context specified in 2 a and 2 b better information is needed regarding the relationship between a book and its authors. Specifically, it is important to record the percentage of the royalties that belong to a specific author whether or not a specific author is a lead author of the book and each author's position in the sequence of the book's authors.
d- A book (2a) can be part of a series which is also identified as a book and has its own ISBN number. One book can belong to several sets and a set consists of at least one but potentially many books.
e- A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model. Over time, the company often manufactures thousands of pianos of a certain model and the model designer specified before any single piano exists.
f- A piano manufacturer (see 2 e) employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customer. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and quality evaluation grade.
g- The piano technicians (see 2f) have a hierarchy of reporting relationships. Some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. The supervisors themselves report to the chief technician of the company.
h- A vendor builds multiple types of tablets computers. Each has a type identification number and a name. The key specifications for each type include the amount of storage space and display type. The company uses multiple processors types exactly one of which is used for a specific tablet computer type obviously the same processor can be used multiple types of tablets. Each processor has a manufacturer's unique code that identifies it.
i- Each individual tablet computer manufactured by the vendor (see 2 h) is identified by the type identification number and a serial number that is unique within the type identification. The vendor wants to maintain information about when each tablet is shipped to a customer.
j- Each of the tablet computer types (see 2h) has a specific operating system. Each technician the company employs is certified to assemble a specific tablet type- operating system combination. The validity of a certification starts on the day the employee passes a certification examination for the combination and the certification is valid for a specific period of time that varies depending on a tablet type operating system.
Solved
Show answers
More tips
- L Leisure and Entertainment Unlocking the Secrets of Winning the Lottery...
- S Style and Beauty Ultimate Guide on How to Care for Suede Shoes...
- S Sport Running: How to Do It Right?...
- F Food and Cooking How to Cook Spaghetti Right – Secrets and Tips...
- P Philosophy Personal attitude towards Confession: how to prepare and undergo the procedure correctly?...
- H Health and Medicine Flu: How to Recognize It by the First Symptoms?...
- F Food and Cooking How to Sober Up Quickly? Important Facts and Tips...
- H Health and Medicine How to Properly Take a Blood Sugar Test?...
- H Health and Medicine Simple and Effective: How to Get Rid of Cracked Heels...
- O Other How to Choose the Best Answer to Your Question on The Grand Question ?...
Answers on questions: Computers and Technology
- C Computers and Technology Join my zoom Meeting id is 952 594 9981. The password is 2020...
- C Computers and Technology jeremy is working on a spreadsheet. Which part of the information processing cycle will justify jeremy’s use of the spreadsheet and give the final output?...
- M Mathematics Helppp 33 pls and ty.....
- M Medicine What domains should be considered when tailoring patient education and how can these domains hinder a patient s ability to follow a rehabilitation goal?...
- M Mathematics A tomato plant at Martha’s garden is 0.853 meters and a corn stalk 0.891 meters how do you round both measures to the nearest tenth?...
- L Law Paige is trying to calculate the value of each of her department s inventory and overall inventory. Womens clothes are35% of her overall inventory which is $3,200,000....
- C Chemistry How do I identify methyl groups from pictures, Are all the ch3 groups in these pictures methyl or is there some kind of rule to classify them?...
- H History Why did the Aztecs keep their captives alive? 1. They had a moral objection to killing.2. To feed to their pets.3. For human sacrifice.4. To train them for their own armies....
- E English Which two words would BEST replace “relatively” and “fuel” in the selection above WITHOUT changing the meaning?...
- H History Why is building a culture important? answer : It defines the values , norms and guidelines that you live by....
Ответ:
nope
Explanation: