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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!