Assignment 4/Project 1
For this project you will create a database for a virtual library.
The books from the library can be “checked out” by Users for a fixed period of time. For this assignment let us assume that books cannot be renewed. A User may check out any number of books at a time. Since the books are eBooks, any number of Users can check out a book at the same time.
Design/create the database tables carefully first.
Insert at least 3 books, 5 users. The database must contain information about at least 5 check outs of books.
Write the queries below (Obviously, your database must be designed so that it can support these queries):
The virtual library has added a new social media feature. Users can now post and view comments about books they have checked out. Your database design must support this feature. For each book and User, we need to store the comments made about the book by the User
Each check out must contain at least 3 comments about the book by the User who has checked out the book.
Write the queries below (Again, your database must be designed so that it can support these queries)
What to Submit:
This is doable without any SQL tool but of course you can check your work better with one. You can use Access, SAS SQL, MySQL, etc.
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
PLACE THIS ORDER OR A SIMILAR ORDER WITH USA ELITE WRITERS TODAY AND GET AN AMAZING DISCOUNT