Category: Databases

Ray Henry owns Henry Books, a bookstore chain. In running a chain of bookstores,

Ray Henry owns Henry Books, a bookstore chain. In running a chain of bookstores, Ray gathers a variety of information on branches, publishers, authors, and books. For this assignment, you will work in a database called Henry Books to create SQL queries to answer business questions.
In MySQL Workbench, create a database named FirstName_LastName_HenryBooks. As an example
Run the MySQL-Henry file (attached bellow) to add the tables and data to the HenryBooks database. For answers, please use SQL_Ansewrs_sheet (attached bellow) and rename it as FirstName_LastName_IT310Assignment3.
Write SQL statements for the following questions.
Business Questions
Question #
Question Text
Question #1
What are the titles and publisher codes for all books that belong to one of the following types: SFI, HOR, POE?
Question #2
What are all of the book types, in alphabetical order, listing each book type only once, sold by the bookstore?
Question #3
For each type of book available in the bookstore, what is the type of book and the average price for a book of that type?
Question #4
What are the titles and prices of all books that sell for at least $20, but no more than
$30? The answer should be sorted from the highest price book to the lowest price book.
Question #5
What is the title and price of all books published by Basic Books with a price more than $10?
Question #6
How many books have been written by Toni Morrison? Your answer must reference the string values Toni and Morrison.
Question #7
What is the title of every FIC book that has been published by Penguin USA?
Question #8
Ray wants to check the inventory of all four branches. Provide a report of every book in the database including the book code, title, price, the number in stock, and the branch number.
Question #9
Show every author in the database including the first name, last name, and the book code of book(s) they have authored. For an author who does not have any authored books, the value for book code should be NULL. Order the results by last name in alphabetic order.
Extra credit (5 points)
What are the title(s) and price(s) of the least expensive book(s) in the database? (Extra credit can only be granted when you retrieve the required information in ONE query.)
How Will This Assignment Be Graded?
Sample Student Submission (Just the first two questions)
/**
Question 1: List all information known about all books.
**/
SELECT *
FROM book;
/**
Question 2: List all the publishers located in New York. Sort the results in alphabetic order.
**/
SELECT Publisher_Name
FROM publisher
WHERE city = ‘New York’
ORDER BY 1;

Deliverable: Draw an Entity-Relationship Diagram using ER-Assistant or equivalen

Deliverable: Draw an Entity-Relationship Diagram using ER-Assistant or equivalent software. The deliverable is a complete ER model for the following scenario.
The ER diagram must include the necessary entity classes and all attributes specified in the description.
Identifiers for all entity classes must be shown clearly.
Relationships must be named, with cardinalities clearly shown.
Write down your assumption clearly if necessary
Do your best, if you are having troubles, please write that out with the assumptions. Document any assumption you have to make.
There are multiple right answers for this problem, so please don’t compare with others, as you can all read the case differently.
PLEASE UPLOAD THE ER MODEL (As a ERD,JPG,PNG, or PDF) AND THE Assumptions (a separate word or text document) to Canvas, Assignment 1. All entity class names and attribute names should start with your initials. No grade will be granted without your initials added.
Case Description
A trucking company (called TRUCKERS Inc.) is responsible for picking up shipments from warehouses of retail chain called MAZE and delivering the shipments to individual retail store locations of MAZE. Currently MAZE has 6 warehouses and 45 retail stores.
A truck may carry several shipments during a single trip. Each trip is identified by a “Trip #”.
The shipments on a single trip may be delivered to multiple stores. Each shipment is identified by a Shipment # and includes data on volume, weight, destination, expected delivery date, and the date shipment was picked-up.
Trucks have different capabilities on both volumes they can hold as well as the weights they can carry. TRUCKERS currently have 150 trucks in its fleet and each truck may make 3 to 4 trips per week.
A database that will be used by BOTH TRUCKERS AND MAZE is being designed to keep track of the truck usage and deliveries and to help in scheduling the trucks to provide timely deliveries to the retail stores. You are not creating a database now, you are doing the design by creating the ERD.

i have added assignment solve only 1 and 3. for ques 3, i have added screenshots

i have added assignment solve only 1 and 3. for ques 3, i have added screenshots of given tables, u need to add data into the tables as per question

hi I have a final exam on database management and i only have an 1 hour to submi

hi I have a final exam on database management and i only have an 1 hour to submit the final. there is a sample for the exam but it is not the same as the real one.

you’ll need to work on a ipynb file that I have attached, refer to “copy of ques

you’ll need to work on a ipynb file that I have attached, refer to “copy of question PDF” for instructions, everything else is attached for your reference, including codes and Class Content for your reference to answer the assignment, YOU NEED TO FOLLOW/REFER TO THE CODES AND CLASS CONTENT TO ANSWER THE QUESTIONS DO NOT ANSWER BASED ON YOUR BEST GUESS OR PAST KNOWLEDGE, follow each instruction on the PDF very carefully, remember you are using posterSQL

Draw complete ER/EER diagram. Identify entities (superclass/subclass), attribute

Draw complete ER/EER diagram. Identify entities (superclass/subclass), attributes, primary keys, relationships and participation controls
Map the ER diagram into relations
Apply normalization (3rd normal form)
Write SQL statements for the following:
Creating all tables with appropriate data types and constraints
Filling all tables with minimum 3 records.

Hi i need answers for this diagrams and Presentations DIAGRAMS must be original

Hi i need answers for this diagrams and Presentations DIAGRAMS must be original work not a picture from google Presentations need to be 5 slide 1 intro and the other 4 make it part 1 part 2 part 3 part 4 EACH Slide must be 6 lines

Those with a PC with MS Office with Access complete this section. MacOS users or

Those with a PC with MS Office with Access complete this section. MacOS users or PC Users without MS Access see below.
Background Resources(PC or Mac)
Database Overview PowerPoint

Instructions/Starter File (MS Access)
AccessCS-InClass.pdf
LooneyTunes-InClass.xlsx (Right click and Save As to download the starter Excel file)
Instructional/Helper Videos (MS Access)

Submit the following files (MS Access)
(1) Completed Excel file
(2) Access Database (.accdb) file. NOTE – Close Access before uploading
(3) PDF export of the report
Rubric (MS Access)
LooneyTunes-GradeSheet.xlsx
=====================================================================================
MacOS users or PC Users without MS Access complete per below
NOTE – For MacOS students, if you get a Java error, please see below guidance at the bottom of the page.
Instructions/Starter File (Libre/OpenOffice Base)
LibreBase-InClass.pdf
ActionsDownload LibreBase-InClass.pdf (Mac OS Users – There are workarounds on steps 15 and 17)
LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsx
LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsx Download LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsxInstructional/Helper Videos (Libre/OpenOffice Base)
Normalizing Excel for import into LibreOffice Base
Relationships and QueriesLinks to an external site.
Creating Reports and Exporting
Submit the following files (Libre/OpenOffice Base)
(1) Excel file
(2) LibreOffice or OpenOffice Base file (close LibreOfficeBase/OpenOfficeBase before uploading)
(3) PDF export of the report
Rubric (Libre/OpenOffice Base)
LooneyTunes-GradeSheet-Libre.xlsxDownload LooneyTunes-GradeSheet-Libre.xlsx
Links to an external site.
MAC OS Users Troubleshooting – Do these in the following order
Go to this siteLinks to an external site. to download Java for Mac OS and then run LibreOffice.
Launch LibreOffice. Navigate to the preferences window (“LibreOffice” menu in the top left corner of the screen, then ‘Preferences’). Select ‘Advanced’ from the list of options on the left hand side. This should display the preference options for Java. If the installation of the JDK has gone well, it should already have a tick in the option for ‘Use a Java runtime environment’. In the pane below that, a radio button should indicate that the vendor is Oracle Corporation
If there is no Java package selected, you can add it manually. Click on the ‘Add’ button on the right hand side of the preference window. A normal Mac OS file dialogue box will open. Using that, navigate to the top of your Mac’s hard disk. This should list the following folders: Applications, Library, System, Users. Select ‘Library’. In the Library folder select ‘Java’, then ‘JavaVirtualMachines’. Within that, select the most recent (probably only) version of the JRE. Then, within that ‘Contents’, then ‘Home’. Then press the ‘Open’ button on the MacOS dialogue box to select that as the location.
If this does not work, please try OpenOffice in lieu of LibreOffice. You can download hereLinks to an external site.. Since OpenOffice is not digitally signed, you will need to right click, then select Open. The instructions for the table imports have a few notes for Mac OS (steps 15 and 17), but otherwise the instructions are the same for LibreOffice and OpenOffice. NOTE – The screens are slightly different between LIbreOffice and OpenOffice.

There is solved file , All I want is for the solution to be completed in the sam

There is solved file , All I want is for the solution to be completed in the same way as the solved file , but neveer to be copied and pasted and it must be in a different format.

hello, i have a project the instructions are clear in the file but in the last q

hello, i have a project the instructions are clear in the file but in the last qusetion there are an error, so our dr said that we can assume attributes if we could not get an outcome, so you can assume an attribute only to the last question without chaning anything else in other questions or adding anything not all the last question only in part h . of corse the answer should not have any palagresim
,and there an solved file just for an example how to solve it if you want it i will share it with you