PRACTICE DATABASE DESIGN PROBLEM
Imagine that your town library wants to keep track of...
PRACTICE DATABASE DESIGN PROBLEM
Imagine that your town library wants to keep track of its business in a database, and that you have been
called in to build the database. You talk to the town librarian, review the old paper-based records, and watch
people use the library for a few days. You learn the following about the library:
1. Any resident of the town can get a library card simply by asking for one. The library considers
each cardholder a member of the library.
2. The librarian wants to be able to contact members by telephone and by mail. She calls
members when their books are overdue or when requested materials become available. She likes to
mail a thank-you note to each patron on his or her anniversary of becoming a member of the
library. Without a database, contacting members efficiently can be difficult; for example,
multiple members can have the same name. Also, a parent and a child might have the same first and
last name, live at the same address, and share a phone.
3. The librarian tries to keep track of each member
s reading interests. When new books come in,
the librarian alerts members whose interests match those books. For example, long-time
member Sue Doaks is interested in reading Western novels, growing orchids, and baking bread.
There must be some way to match her interests with available books. One complication is that,
although the librarian wants to track all of a member
β
s reading interests, she wants to classify
each book as being in just one category of interest. For example, the classic gardening book
Orchids of France would be classified as a book about orchids or a book about France, but not
both.
4. The library stocks thousands of books. Each book has a title and any number of authors. Also,
more than one book in the library might have the same title. Similarly, multiple authors might
have the same name.
5. A writer could be the author of more than one book.
6. A book will be checked out repeatedly as time goes on. For example, Orchids of France could
be checked out by one member in March, by another member in July, and by another member
in September.
7. The library must be able to identify whether a book is checked out.
8. A member can check out any number of books in one visit. Also, a member might visit the
library more than once a day to check out books.
9. All books that are checked out are due back in two weeks, with no exceptions. The late fee is
50 cents per day. The librarian would like to have an automated way of generating an overdue
book list each day so she can telephone offending members.
10. The library has a number of employees. Each employee has a job title. The librarian is paid a
salary, but other employees are paid by the hour. Employees clock in and out each day.
Assume that all employees work only one shift per day and that all are paid weekly. Pay is
deposited directly into an employee
β
no checks are hand-delivered. The
database needs to include the librarian and all other employees.
β
s checking account
β
s database, following the rules set forth in this tutorial. Your instructor will specify the
format of your work. Here are a few hints in the form of questions:
Design the library
β
A book can have more than one author. An author can write more than one book. How would
you describe the relationship between books and authors?
The library lends books for free, of course. If you were to think of checking out a book as a sales
transaction for zero revenue, how would you handle the library
β
s revenue-generating event?
A member can borrow any number of books at one checkout. A book can be checked out more
than once. How would you describe the relationship between checkouts and books?
Answers: 1
Business, 21.06.2019 20:30
Long-distance providers are becoming increasingly concerned about certain activities within their industry. various companies come together voluntarily to implement new standards of social responsibility that members must abide by. what seems to be the primary motivation in this case for an increased interest in social responsibility? - because corporations are creations of society, they are responsible for giving back to the communities in which they operate.- these companies have realized it is in their best interest to increase their social responsibility before they are once again subject to stricter regulations.- these companies are using social responsibility as a means to increase their profitability, both short term and long term.- long-distance providers have started taking pride in their industry and its record for social responsibility.- they feel a responsibility to their stockholders, employees, the government, investors, and society as a whole.
Answers: 2
Business, 21.06.2019 21:00
Add the mips assembly language instructions (after main: ) to complete the following (in this order). do not skip steps. use other registers as needed. actions: 1. initialize the register $s0 to 35 2. prompt the user to enter a number, read the number and then put it into register $s1 3. prompt the user to enter a number, read the number and then put it into register $s2 4. store the value in $s1 into the memory at address 0x10010000. 5. store the value in $s2 into the memory at address 0x10010004. 6. calculate the value of $s0 - $s1 $s2 and store the result in the memory at address 0x10010008. 7. print the following output each on its own line. you will need to determine the location of each of the strings from the beginning of the memory segment a. your name b. the value in address 0x10010000 c. the value in address 0x10010004 d. the value in address 0x10010008 8. exchange or swap the values in $s1 and $s2 9. set the value in $s0 to -$s0
Answers: 2
Business, 22.06.2019 05:00
Xie company identified the following activities, costs, and activity drivers for 2017. the company manufactures two types of go-karts: deluxe and basic. activity expected costs expected activity handling materials $ 625,000 100,000 parts inspecting product 900,000 1,500 batches processing purchase orders 105,000 700 orders paying suppliers 175,000 500 invoices insuring the factory 300,000 40,000 square feet designing packaging 75,000 2 models required: 1. compute a single plantwide overhead rate, assuming that the company assigns overhead based on 125,000 budgeted direct labor hours. 2. in january 2017, the deluxe model required 2,500 direct labor hours and the basic model required 6,000 direct labor hours. assign overhead costs to each model using the single plantwide overhead rate.
Answers: 3
Business, 22.06.2019 05:50
Match each of the terms below with an example that fits the term. a. fungibility the production of gasoline b. inelasticity the switch from coffee to tea c. non-excludability the provision of national defense d. substitution the demand for cigarettes
Answers: 2
Mathematics, 09.06.2020 20:57
English, 09.06.2020 20:57
History, 09.06.2020 20:57
Mathematics, 09.06.2020 20:57
Mathematics, 09.06.2020 20:57
Mathematics, 09.06.2020 20:57
English, 09.06.2020 20:57
Mathematics, 09.06.2020 20:57
Social Studies, 09.06.2020 20:57
History, 09.06.2020 20:57