MYSQL bb.snhu.edu upload Assignment: 6-... https://bbenhu.edu/bb... Codio dad 22
ID: 3819183 • Letter: M
Question
MYSQL
bb.snhu.edu upload Assignment: 6-... https://bbenhu.edu/bb... Codio dad 220-sq-... Construct the SQL stat Chegg Study IGuided Home Students mysql how to display c overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final project, you will apply the skills you learned in order to demonstrate your mastery of the key concepts necessary for effective database management. These are skills you will be able to apply to your future courses as well as your career in managing information systems. Prompt: The third milestone assignment covers the final major concept of this course-data retrieval. In the first milestone assignment, you created a database from scratch. In the second milestone assignment, you made alterations to an existing database and manipulated the data within it. For this assignment, you will apply what you learn about data retrieval to create some queries to extract insightful information from the database. Like in the first two assignments, you will use MySQL in the Codio learning environment. In addition to submitting the queries that you created, you will provide a written report explaining your work. Directions: Your first two projects required youto manage databases and manipulate the data for the human resources and flight reservations systems. Fortunately, the scheduling system for SNHU Airlines is functional and does not require any modifications. The company executives would like some reports on the employees' meetings though, so you have been asked to create some queries to extract information from the database. Refer to the Database Schema section for details on the database Database SchemaExplanation / Answer
Following are the sql statements.
1. Select person.first_name,person.last_name,building.building_name,room.room_number,meeting.meeting_start,meeting.meeting_end
From person_meeting,person,meeting,room,building
where person_meeting.person_id = person.id and person_meeting.meeting_id = meeting.meeting_id and meeting.room_id = room.room_id and room.building_id = building.building_id and person.first_name = "Tom" and person.last_name = "Hanks"
2. Select person.first_name,person.last_name,building.building_name,room.room_number,meeting.meeting_start
From person_meeting,person,meeting,room,building
where meeting.meeting_id = 2 and person_meeting.person_id = person.id and person_meeting.meeting_id = meeting.meeting_id and meeting.room_id = room.room_id and room.building_id = building.building_id
3. Select person.first_name,person.last_name,building.building_name,room.room_number,meeting.meeting_id,meeting.meeting_start,meeting.meeting_end
From person_meeting,person,meeting,room,building
where person_meeting.person_id = person.id and person_meeting.meeting_id = meeting.meeting_id and meeting.room_id = room.room_id and room.building_id = building.building_id and building.building_name = "Main Street"
4. Select count(person_meeting.person_id),meeting.meeting_id,meeting.meeting_start,meeting.meeting_end
From person_meeting,meeting
where person_meeting.meeting_id = meeting.meeting_id
groupby person_meeting.meeting_id
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.