Create a database for an elementary school library which contains at least the following information:
Enter the appropriate information for at least 10 students and 10 books into the database and arrange it so that exactly 5 of the books are charged out, 3 of them to the same student. At least two of your books must have the same title (but be different books), and at least two of your students must have the same name (but, of course, be different students!).
Construct two queries. The first should show the title of each book that is charged out, the name of the student to whom it is charged out, and the due date. The second query should simply show the name of each student at the school.
Many of the things you will need to decide when designing your database have not been specified in this assignment. For example, the form of a student's name (e.g., first and last, nickname, middle initial, etc.) has not been specified. Nor has the maximum length of a book's title. You may make any reasonable decisions about things which are not specified in this assignment.
Please email your database (i.e., the tables and two queries in one mdb or accdb file) to the teaching assistant before class on the date that this assignment is due.