Hands-On Assignments
To perform assignments 1 to 5, refer to the table
structures in Figure 1-5 and the table listings in Appendix A.
1.
Which tables and fields would you access to determine which book titles have
been purchased by a customer and when the order shipped?
Table CUSTOMERS-Customer#, Table ORDERS-Order#, Shipdate,
Customer#, ORDERITEMS-Order#, and the table BOOKS- isbn and title are the
tables and field I would access to determine which book titles have been purchase by a customer and the order
shipped.
2.
How would you determine which orders have not yet been shipped to the customer?
I would determine which orders have not
been shipped to the customer by classifying which all orders that does not include admittance for the dates
shipped.
3.
If management needed to determine which book category generated the most sales
in April 2009, which tables and fields would they consult to derive this
information?
The tables and fields that they would consult to derive that
information would include ORDERS: Orderdate, Order#, ORDERITEMS, ISBN, Quantity
and the field Paideach.
4.
Explain how you would determine how much profit was generated from orders
placed in April 2009.
In the beginning the amount of profit generated should be
Determined by each book on an order item. Then, increase the profit for each
book by the quantity purchased. After that,
total the amount of profit generated by all orders placed in April.
5.
If a customer inquired about a book written in 2003 by an author named
Thompson, which access path (tables and fields) would you need to follow to
find the list of books meeting the customer’s request?
The access path that they would need
follow to find list of books meeting the customer’s request, would be tables;
AUTHOR, BOOKAUTHOR and BOOKS, with the fields; Lname, AuthorID, Pubdate and
ISBN.
Create an initial database design (E-R model) for a library that will serve a local elementary school. Please include entities, attributes, primary keys and relationships in your answer. Also, write down basic assumptions that your database library would (and would not) support, similar to the Basic Assumptions section on page 13.
Basic Assumptions:
· Students will borrow books based to help with
school assignments but most will borrow reading books as it’s an elementary
school
· Regular follow-ups will be done for books that
are outstanding, as some students might be waiting to borrow a book that has
not been returned
· The database won’t have much discrepancies, as
the librarian would be familiar with the students, as it will be located within
the school, and follow-ups can be done on a daily basis
0 comments:
Post a Comment