SQL Simple Queries
Use the following database schema to express the following queries in SQL:
CUSTOMER (CUSTID, CUSTNAME, ANNUALREVENUE, CUSTTYPE)
SHIPMENT (SHIPMENT#, CUSTID, WEIGHT, TRUCK#, CITYNAME, SHIPDATE)
TRUCK (TRUCK#, DRIVERNAME)
MusicMash is a startup business specializing in online music streaming. After
receiving initial funding from investors, the founders of MusicMash are ready to start
developing their online business. The owners are University of Arizona MIS
Due: Knowledge Check for Class 4
On a balance sheet, assets must equal the sum of liabilities and equity
-Who am I? (Integrity vs. Loyalty)
-Who are we? (Organizational ethical values, short term vs. long term)
MIS 331 Peer Evaluation - Project Interim Report 2
Each person on the team must complete one of these forms. Failure to do so will result in a one-letter-grade reduction of your personal grade for the project.
You must also follow the instructions Evaluat
MKTG 361: Phase II
Due October 26th
This semesters project will incorporate the knowledge, skills, & strategies used in several of your
core curriculum courses. The ability to coordinate this project will allow the groups t
Midterm Study Guide
1. Introduction to Database
We started off with a discussion of the evolution of databases. You should be familiar with this discussion most specifically:
a. what are the different types of databases?
b. what are the advantages and dis
Introduction to SQL
NOTE: All queries in this lecture refer to the
tables on slide #2. It will be easier if you
make a full page copy for your reference
and use during class.
Overview of SQL Topics
Creating the database
Practice AKA Fake Problems
What normal form is it in NOW, why? Fix it so its in 3NF (at least)
SALE(Date, Customer, Product, Vendor, Vendor_City, Salesrep)
FD: Customer Salesrep; TD: Vendor Vendor_City
Answer: 1NF, Violation: Partial Functional Dependency
Some More SQL
How queries really work
Group by and Having
How do queries work?
Statements are processed in the following
A Join must be used when data in the select
Assignment 2: Normalization
For this assignment, you need to answer three questions about normalization. Make sure that you read the
You must write your answers in a single Word document.
You must include your name at the
Bonus Assignment 1: ER Modeling
Create ER models for the following three scenarios. Make sure that you read the description carefully. Your
diagram should reflect all entities, relationships, and attributes mentioned in the text. You may make
MIS/ACCT 3353: Homework 1
These all ask you to create ER diagrams. Please be sure to include all components (parts of the
model and assumptions) and all necessary notation.
1. Worth 30 points
A real estate firm lists property that is for sale. The firm ha
MIS 331 Assignment 1: ER Modeling
Create ER diagrams for the following three scenarios. Make sure that you read the description carefully.
Your diagram should reflect all entities, relationships, and attributes mentioned in the text. You may