Think of a database that would be needed at a professional service firm to maintain the contact list of clients/patients at the office of a CPA, attorney, or medical doctor. Identify the fields likely to be used in this database. If one person were constructing this database, how many spaces would it allow for each field?

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.

A member of The perspective of the head is thus: It's a database, and the fundamental design/structure we picked contains some sensitive driver information." How about putting it in a secure location where only those who need it may access it? Is there a tactic you'd prefer, or a position you'd take? Justification is required....

A taxi company would like to provide an online service for customers to book a trip and for taxi drivers to check their upcoming trips. A database needs to be created to store customer data (name, address, email, telephone number) and trip information (pick up and drop off address and pick up time and date). Furthermore, your database should contain driver information (name and license plate). Each trip must be assigned to exactly one driver (and trips for a driver must not overlap). Customers who are not registered yet need to register (providing their address, phone number, email address, and credit card information). A registered customer should be able to book a trip, i.e. provide the pick-up address and time as well as the drop-off address via a graphical user interface. Customers should also be able to view their trips and cancel them if needed. All these operations are only possible after a customer signs in (which means they must be registered). Each new trip must be confirmed…

Database design diagrams (DBDL) and entity-relationship (E-R) diagrams (ER) are both valid ways to depict a database's structure. For what reasons do you choose one tactic over another?