The library handles books. Books have a title, author, ISBN, and additional relevant data you think are needed. Books are identificed by a barcode. There can be many copies of the same ISBN but only one copy of an actual book per barcode. These books reside in the library on shelf locations. A shelf location is made up of the aisle, row, cabinct, and shelf numbers A book can have only one location, but shelves are wide and can contain many books. Some shelves may be left empty on purpose. The library lends books to patrons. A patron is identified by an ID Additional information about each patron, mcluding namc, address, telephone numbers, and email addresses must also be kept. A patron can have many telephone numbers and emails. The library keeps track of which books have been lent to each patron, when the books were lend out, when they were returned. Also keep track of the categornes of each book. A book can have many categories, such as MIS, Biology, Literature, etc., but must have at least one.

The library handles books. Books have a title, author, ISBN, and additional relevant data you think are needed. Books are identificed by a barcode. There can be many copies of the same ISBN but only one copy of an actual book per barcode. These books reside in the library on shelf locations. A shelf location is made up of the aisle, row, cabinct, and shelf numbers A book can have only one location, but shelves are wide and can contain many books. Some shelves may be left empty on purpose. The library lends books to patrons. A patron is identified by an ID Additional information about each patron, mcluding namc, address, telephone numbers, and email addresses must also be kept. A patron can have many telephone numbers and emails. The library keeps track of which books have been lent to each patron, when the books were lend out, when they were returned. Also keep track of the categornes of each book. A book can have many categories, such as MIS, Biology, Literature, etc., but must have at least one.

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this design? Why? What should be done to correct the design?
Open your text editor and create a new document named model.php model.php will connect to a database potentially return PDO statement objects to the controller for processing. This question is complete and requires use of initMessagesfunction initMessages($tim) This method will take a single parameter of unix time using the method “time()”. It will conditionally select fromthe table “messages” the minimum id and rename it to “min_id”. The condition is that the field time is greater thanthe parameter for time. The return is the PDOStatement object with the row data from a query.
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are. The structure of the tables is described in the following crows foot ERD:
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are.
A student database may include indexes on fields such as major, age, marital status, and home zip code in addition to the main key, which is the student's unique identifier (all secondary keys). Let's assume the school wants a list of MIS or CS majors over the age of 25 who are married and from the 45462 zip code OR a list of CS majors under the age of 25 who are single and from the 45462 the code. Is there a way to utilize indexes to restrict access to just the records that meet this criterion?
Imagine a database of students where the StudentID is the main key, and there are other indexes on Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Let's assume the institution wanted a list of MIS or computer science majors who were over 25 and married and were from the 45462 postcode code OR computer engineering majors who were single and were from the 45462 zip code. In any case, they wanted the list to come from the 45462 zip code. How can indexes be used to guarantee that individuals will only have access to the info that fulfills this prerequisite?
The screen shown is used to enter the sales of the products into the sales and salesdetails tables. It utilizes the four depicted files ProductDAO.java, Product.java, PosDAO.java and Pos.java. The schema for the database is also depicted. The java code utilizes a jconnector to retrieve data from the database. When a product code is entered and then a quantity is entered, on the enter key pressed, the product code is sent to the getProduct(String ID) of a ProductDAO object and that function connects to the database and retrieves the data, placing it into a Product object and return this as Product object so that it can be placed into the Jtable of the PosGUI screen. Write the code for the getProduct(String ID) function located in the ProductDAO file. The code is equivalent to the prodid.
Imagine a browser-based training system that helps students prepare for a certification exam. Astudent can request a quiz from the system. The system picks a set of questions from its databaseand composes them together to make a quiz. It rates the student’s answers and gives hints if thestudent requests it. Tutors also use the system by providing questions and hints and examinerswho certify questions to make sure they are not too trivial.a) Draw a use case diagram from the description above
Create a flowchart of how a product is bought from a candy company and the manufacturing of products in the same candy company. It should feature processes that check for stock, the sale of it, and the manufacturing of it. We should be able to see the use of a centralized database.
Q. Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examiners who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying “Make Quiz” functional requirement.
Draw an ERD for the following problem. Help design the backend database for a startup company (imagine Facebook back in the “old” times), which plans to launch a social media platform that allows USERS to share their “MOMENTS” (like a posting) with their FRIENDS. A user may have some FRIENDS who are users of the system as well. A User can send a request to another user to become a friend. A user and his/her friend can post COMMENTS and LIKES to a MOMENT. Draw an ERD and show some important attributes (e.g., key, username, password, moment posting time, etc.). Clearly state any assumptions. When possible, convert to associate entities.
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…