DBM 380 Week 5 Individual: SQL Queries

DBM 380 Week 5 Individual: SQL Queries

Author: Alon Padson


The following assignment is based on the database environment created in the Week Four Individual Assignment.
Design and develop the below queries using professional principles and standards:
A set of SQL Statements that returns all rows and all data for each table in your database.
Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
Two SQL Statements that join two or more tables in one query.  Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.
Submit an .sql file with the scripts needed to create the required queries and submit the file using the Assignment Files tab.

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.