Question: Create a library check-out database using Microsoft SQL Server that stores data about books, patrons, and the check-out process. Apply the concepts of database systems
Create a library check-out database using Microsoft SQL Server that stores data about books, patrons, and the check-out process. Apply the concepts of database systems that you have learned so far. Be sure to include tables, fields, keys, relationships, and test data in your database.
Part II. Submit a paper with headings and screenshots in this order:
The design of your tables.
A diagram of your tables.
SQL queries selecting all data from all tables.
The data results from the queries showing the data from each table.
An SQL query using a WHERE clause with an AND operator.
The data results from the query using a WHERE clause with an AND operator.
An SQL query using a WHERE clause with an OR operator.
The data results from the query using a WHERE clause with an OR operator.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
