Index

Assignments

Syllabus

Schedule

Class Details

Office Hours

Course Assignment Overview

cim.saddleback.edu has a MySQL/MariaDB database available for you. We hand in all assignment using the submit command. Pay attention to what each assignment query is asking, computers do what you say not what you want. Almost all assignments also have a corresponding blackboard quiz, the quiz and assignment name always match. In all pre-book assignment you also have a set of matching videos.

Each assignment description has three parts:

  1. Objectives of Assignment
  2. Synopsis concise steps with links for completing assignment
  3. Checklist Completion Steps which is a detailed description of how to complete assignment.

To complete this class simply begin at the first assignment work top - down. The blackboard Welcome announcement has all key due dates, quizzes do expire but assignments will be graded at end. Key to success in any on-line course is too stay up with the work. In this logic oriented class whereby material builds on itself, you need to both stay up with the work and master the work. You need to understand the tutorial.sql videos before progressing to the next level.

I will be sending out e-mail reminders informing where you should be in the course. You can always complete the course early. Once again complete all assignments in order they listed (i.e., top down).

Intro aka Course Orientation

Objective:

Basic introduction to course, you will have to gain experience in using the browser back button, and navigating three sites using browser tabs.

Synopsis:

  1. Complete all steps at http://cim.saddleback.edu/de

  2. Make sure you watch a blackboard orientation Web-cast or attend Mondays 2PM 6/15/2015 Web-casts.
  3. Take blackboard Quiz 0 Intro,
  4. Review class Web-site, read syllabus
  5. Print this assignment in PDF page
  6. Print blackboard's Welcome announcement page, use it and this assignment page to create your cimw105 notebook.

Checklist Completion Steps...

  1. Complete all five orientation steps at http://cim.saddleback.edu/de

  2. If you don't watch or attend course specific orientation Web-casts on blackboard, login to blackboard now and watch them.
    Nota Bene, Assignment name, blackboard videos/Web-casts
    and blackboard Quizzes always have the same three names, in these case they are all labeled as Intro.
  3. If you didn't take blackboard Quiz 0 Intro, take it now. Note you can complete entire course just using blackboard (blackboard has all key links).
  4. review class Web-site, read syllabus and scan over this assignment list. Note this is your course guide for the entire course, you don't complete all assignments at once, you work top down on this assignment list. Blackboard quizzes and videos also follow the exact same top down organization. You need to work top down on assignment and watch the corresponding blackboard video and quizzes when the assignment page tells you.
  5. Print this assignment page by clicking the print button (this will be the guide for completing the course ) Nota bene you can set you printer to Adobe pdf (for a pdf hard copy of this page)
  6. Print blackboard's Welcome announcement page (its 3 steps are a concise summary of course requirements). The three step announcement and assignment page should be your first few pages in your cimw105 notebook.

submit tutorial.sql Basic SQL Introduction

Objective:

Basic introduction to SQL, RDMBS, queries, submit and phpMyAdmin, develop skills at using three apps at once: PHPMyAdmin, Video and Submit.

Synopsis:

  1. Print PDF viewgraphs four slides per landscape page (right^click link to save) or PDF two slides per portrait page
  2. Watch first four tutorial.sql blackboard Videos, (pause, think, take notes)
  3. Take tutorial.sql blackboard quiz 1 or 2 times.
  4. Last two videos use phpMyAdmin to complete tutorial.sql assignment. Scripts used to create databases, and print out either PDF Viewgraphs 4/page or Portrait PDF 2 Slides Per Page
  5. Watch the fifth and sixth blackboard Videos
  6. submit first 5 queries for tutorial.sql (10 possible points),
  7. Watch 7th blackboard Video tutorial.sql last 5 queries.
  8. submit tutorial.sql all ten queries.
  9. Optional watch a pre-recorded blackboard Web-casts before or after tutorial.sql blackboard videos.
  10. Finish all attempts on tutorial.sql blackboard quiz
  11. Review consistency notes listed at end.

Checklist Completion Steps

  1. Print PDF viewgraphs four slides per landscape page (right^click link to save) or PDF two slides per portrait page.
  2. Watch the first four tutorial.sql blackboard Videos (Intro Database, Intro MySQL/SQL, SQL Command Overview and IDE Video). Scripts to Create Fruit Tables and other cimw105 tables.
  3. Take tutorial.sql blackboard quiz 1 or 2 times. (Retake it after submitting tutorial.sql)
  4. Last two videos use phpMyAdmin to complete tutorial.sql assignment. Scripts used to create databases, and print out either PDF Viewgraphs 4/page or Portrait PDF 2 Slides Per Page
  5. Watch the fifth and sixth (tutorial.sql 1st 5 Queries and tutorial.sql submit) blackboard Videos
  6. submit first 5 queries for tutorial.sql (10 possible points),
  7. Watch 7th blackboard Video tutorial.sql last 5 queries.
  8. Optional watch a pre-recored blackboard Web-casts before or after tutorial.sql blackboard videos.
  9. submit tutorial.sql all ten queries.
  10. Finish all attempts on tutorial.sql blackboard quiz
  11. Review consistency notes listed at end.
  12. Deprecated, you can also watch either the putty and/or Workbench path videos, but first complete the tutorial.sql assignment using the current phpMyAdmin videos. As the definition, of deprecated implies, both paths putty and workbench create a different tutorial.sql which is not longer supported.

Consistency Notes...

  • all submit filenames are lower case and always end in .sql
  • phpMyAdmin is mapping all functions names to upper case but we use all lowercase function names for submit
  • all function arguments have a space before and after (we use sum( price ) not sum(price)
  • for fruit database all tables are lower case
  • for fruit tables all field names are lower case except for ID, (i.e., fruitID)
  • you should use accent marks to delimit table and field names
  • never include database names in your queries, we will always first select a database.

If you have submit errors you can wait until you complete the next assignment select.sql, which goes into indentifying submit errors.

Covers submit using select.sql

Objective:

Become proficient with reading submit error messages, and practice writing very basic SQL queries.

Synopsis

  1. Watch the two blackboard select.sql videos
  2. Optional watch the select.sql 2/12/2014 blackboard Web-Cast
  3. Take blackboard select.sql quiz
  4. submit select.sql, (11 Points), 11 select comments listed next.
  5. Click blackboard quiz grades tab - verify quiz grades
  6. Retake blackboard select.sql quiz, you have three attempts
  7. Check submit grades, try to fix missing points

Ten select.sql Comments....

#s1 Display table:fruit sort by price descending
#S2 display first three rows of table:inventory
#S3 display fruit name and price for all fruit with price > 1.0
#S4 display name and cost as pennies for fruit with ID = 1
# S5 display fruit with price less or equal 1.0, order by ascending price # S6 display contents of table:fruit
# S7 display fruit table ordered by fruitID in descending order
# S8 display fruit name and price for fruit with price of $1.25
# S9 describe or explain field/column info about table:inventory
# S10 display the rows of the three most expensive fruit,
# sorted w more expensive first

Eleven selectOld.sql (Assignment and videos have been updated you may do the previous oen for extra credit) #S1 .. #S11

#S1 display contents of table:fruit

#S2 display first three rows in table:inventory

#S3 display fruit name, inventory quantity sum, price and sum quantity*price displayed as value for each row in fruit

#S4 display number of fruit types (i.e., # rows/records) in table:fruit as count( * )

#S5 display table:fruit sorted by descending price

#S6 display name and cost  as pennies for fruit with ID = 1, try this out using the multiplier as both a literal (i.e., '100') and a number not enclosed in single quotes.

#S7 display total number of pieces of fruit in inventory

#S8 display fruit table ordered by fruitID in ascending order

#S9 display fruitID for each row in table:inventory

#S10 display fruit name, and price from table:fruit

#S11 describe or explain field/column information about table:inventory, you should click previous two links sql has multiple commands

Checklist Completion Steps...

  1. Watch the two blackboard select.sql videos which teaches you how to use the submit command. The submit command includes an automatic grader for query based assignments. Video also complete queries 1-3 and 5. Assignment deals with only two fruit tables: fruit and inventory. You will be adding three more fruit tables (order, orderLine, & customer) in the phpMyAdmin video set.
  2. Optional watch the select.sql 2/12/2014 blackboard Web-Cast
  3. Take the blackboard select.sql quiz
  4. submit select.sql, (11 Points), the 11 select comments are listed above the detailed completion steps.
  5. Click blackboard quiz grades tab - verify quiz grades
  6. Retake blackboard select.sql quiz, you have three attempts highest is recorded, strive for full credit on this quiz.
  7. When you first login to submit grades, or if in grader click the black grade tab, on the grade display, if tutorial.sql and intermediate.sql is not 10/10, & 15/15 respectively, you can fix them now. If you need more background in SQL before fixing them watch the next video sets covering phpMyAdmin.

Intermediate SQL intermediate.sql

Objective:
More advance introduction to SQL, data manipulation, intrinsics, and combining tables.

Synopsis:

  1. Should understand phpMyAdmin and submit.
  2. Prerequisite intermediate browsing skill, at this stage you should have a browser that has four tabs that open automatically to: phpMyAdmin, submit, blackboard and this assignment page.
  3. Watch first 2 blackboard intermediate.sql videos
  4. Deprecated, Optional - watch previous fruitcmds.sql Web-cast or intermediateOld.sql, the intemediateOld.sql queries are extra credit.
  5. submit first 6 queries for intermediate.sql,
  6. Watch the last three blackboard videos
  7. Take blackboard intermediate.sql quiz (10 points)
  8. Submit all 20 queries for intermediate.sql
  9. Retake the blackboard intermediate.sql quiz.

Checklist Completion Steps

  1. This assignment assumes you can login to both phpMyAdmin and submit. If not review the previous video set tutorial.sql.
  2. Prerequisite intermediate browsing skill, at this stage you should have a browser that has four tabs that open automatically to: phpMyAdmin, submit, blackboard and this assignment page. You can have multiple browsers on your computer, I recommend Firefox and Chrome. My Chrome browser is set to automatically open the above 4 pages. My Cyberfox (64-bit) Firefox is used for general browsing. How to use chrome to set default home page tabs. Note safari and Opera are two other worthy browsers.
  3. Log in to blackboard and watch the first two intermediate.sql assignment videos (background and background data manipulation).
  4. Deprecated, Optional - We also have a Web-cast covering a deprecated assignment fruitcmds.sql, or the previous intermediate.sql assignment intermediateOld.sql. IntermediateOld.sql is extra credit..
  5. submit first 9 queries for intermediate.sql, like always they are labeled as #1..#9 comment then query. The file intermediate.sql and back up intermediate.sql.bak is in your cim home folder. Note files is automatically loaded when you login and select assignment using submit. Intermediate.sql is also on-line at cim/~premiere. This file has 3 MySQL commands and 12 comments. For readability, always add comments and blank lines. Will take off points if student don't properly comment their code.
  6. Watch the last three blackboard videos intrinsic, combining tables, programming language interfaces.
  7. Take blackboard intermediate.sql quiz (10 points)
  8. Submit all 15 queries for intermediate.sql. Make sure you comment all queries format is #Number comment, I do check for comments and will take off points for missing comments.
  9. Retake the blackboard intermediate.sql quiz.

phpMyAdmin Introduction

Objective:

Review basic SQL, and become proficient with phpMyAdmin

Synopsis:

  1. Watch first two PHPMyAdmin pmaIntro blackboard videos
  2. Take the blackboard pmaIntro quiz
  3. Watch the next two pmaIntro blackboard videos
  4. Submit the first 5 queries pmaIntro.sql - make sure file is well commented.
  5. Watch the final two blackboard videos for pmaIntro.
  6. Retake the blackboard pmaIntro quiz.
  7. Submit the final 5 queries for pmaIntro.sql.
  8. Try to write the first five queries from scratch using only your comments. Study skill, try to write as many of the first five queries before going to bed. Think about how to solve the ones you cannot while you are falling asleep. The solution may come to your first thing in the morning, but make sure you have pen and paper next to bed to write down the solution. In the past I was working the space based laser control system, this is a typical strategy I and other use to solve complex problems. You need to let the brain unwind while you are sleeping and its typical for solution to come to you first thing in the morning.

 

Submit pmaIntro.sql (10Points) using phpMyAdmin & complete blackboard quiz pmaIntro.

First watch the five blackboard videos covering phpMyAdminIntro. You will be using phpMyAdmin to create a fruit DB. Fruit DB is a simplified version of the textbook's premiere database. The videos will create all 10 pmaIntro.sql queries for you. However, it is important to watch all videos. Also, remember practice makes perfect, after completing assignment and watching the video set, go back and try to create the first five queries using only your comments.

Consistency Check

This assignment is identical to the CIMW245 PHP/MySQL PHPMyAdmin assignment.

Checklist

  1. Make sure first two fruit Tables have been Created using PHPMyAdmin.
  2. Take the blackboard pmaIntro quiz
  3. Submit pmaIntro.sql - make sure file is well commented.
  4. To help develop logic skills, using only comments try to write the first five queries from scratch. If you cannot write all five queries, think about the ones you cannot write before going to bed. Experienced programmers will often think about problems before going to bed, it is typical for the solution to come to you first thing in the morning.

phpMyAdmin View

submit pmaView.sql (15 points) and take blackboard quiz pmaView (15 points).

Watch the blackboard video phpMyAdmin View video set, You must complete all steps detailed below and outlined in the viewgraph/videos.

Checklist

  1. Complete first part of report a pdf data dictionary of altered/updated tables and two views.
  2. Submit pmaView.sql
  3. Take blackboard pmaView Quiz (15 points).
  4. Make sure sure you have all five fruit tables.
  5. Make sure you Create views, you need to capture the SQL query using PHPMyAdmin.

phpMyAdmin pmaReset.sql

submit pmaReset.sql (13 points) and blackboard pmaReset quiz.

Complete the on-line blackboard video phpMyAdmin pmaReset Video, on blackbaord these videos are listed with previous pmaView.sql video set.

Checklist

  1. submit pmaReset.sql.
  2. Take the pmaReset quiz (includes pmaView Questions).
  3. Make sure you can write basic SQL queries from scratch
  4. Create a local file for resetting your database state (default name is db0sbusername.sql)

phpMyAdmin Constraints, Triggers and PLSQL

submit pmaTrigger.sql (15 points) and also blackboard pmaTrigger & if available pmaRoutine quiz

Complete the on-line blackboard video set PHPMyAdmin Trigger (covers constraints, triggers and routines), You will be using phpMyAdmin application to create a database state solution for the fruit DB.

Checklist...

  1. Submit pmaTrigger.sql
  2. The three files: fruitAlter.sql.html, fruitTrigger.sql.html and fruitRoutine.sql.html you have sourced in these assignments have fifteen essay questions built into them. Answer these essay questions to your self, links to the above answers are in premiere. Once you have answered these questions take the pmaTrigger essay quiz.
  3. Complete blackboard pmaTrigger and pmaRoutine quiz.
  4. If you want to work with a more complex database before starting the book, you can attempt the extra credit assignment casinoNoJoin.sql. Historically the book has been easy to read once students complete the pre-book assignments.

PMA Report

 

E-mail me your final phpMyAdmin report (15 points). Your report can be in Open Office, libre office or MSWord format (doc or docx) Google docs or PDF after completing the next assignment. Your final report will have (for the first three parts only the database is selected)....

  1. phpMyAdmin Data Dictionary of all five tables and two views. Save this data dictionary in your phpMyAdmin report. In phpMyAdmin select your database, then click the Data Dictionary bottom link - then look for pdf print option.
  2. Graphic Schema of Views and Tables, illustrating Field Names, Types & Relationships. In phpMyAdmin, select only your database, select designer tab or more → designer. Make sure you select only your database, if you select a table in the database, the designer tab will not be present. Select the phpMyAdmin graphic schema window and press alt^print screen, open your phpMyAdmin report and paste (ctrl^V) the clipboard image.
  3. Select your database, then export tab, export method custom. You must select an export method that will allow you to obtain a text based image of your dabase with column headers both Microsoft word or open office document will work. PDF output places each table on its own page.
  4. Local SQL creation script you created in pmaReset.

  5. Chart view of fruit names and total inventory quantities.
Pre-book Assignments Checklist
tutorial select intermediate pmaIntro pmaView pmaReset pmaTrigger Report
10 15 20 10 15 12 15 15
Pre-book total assignment points: 103
(for summer/15 only pmaTrigger and report Extra Credit)

 

Book Assignments Introduction

Book Assignments...

For both A and B grade you need to complete some text book assignments, consult Syllabus for exact details on course grading.

See schedule for the recommended pace, Blackboard quizzes maintains final due dates and syllabus has deadlines required for maintaining enrollment in class.

Nota Bene, for all assignments except Chapter one, you must submit the assignment using the cim submit command. Refer to the select.sql video set for additional help on submit.

Chapter 1 p21.sql

Read Chapter 1; Complete the premiere product exercises on page 21 questions 1..10, The ten questions in the book are listed after the next paragraph.

The database we are using is on-line Once you have completed the 10 questions on page 21 (aka you have hand written answers), take blackboard Assignment Quiz One; which will verify that you have completed the written portion of the assignment. Assignment one Quiz can not be repeated it will count as part of your quiz grades. Using the results of Assignment quiz one and/or wait until you have completed chapter 3, submit p21.sql. (10 Points) Updated versions of questions adopted from book...

  1. List names of all customers that have credit limit of 7500 or less; remember table and field names upper case.
  2. List order numbers for orders placed by customer number 608 on 10/23/2007
  3. List part number, description and value (price of part * quantity on hand) as "On-hand Value" of all parts in item class SG.
  4. List part number and description of all parts in class HW
  5. How many customers have a balance that exceeds their credit limit?
  6. What is part number, description and price for least expensive part in DB
  7. For each order, list order number, order date, customer number and customer name.
  8. For each order placed on October 21, 2007 list order number, customer number and customer name.
  9. List sales rep number and sales rep last name for every sales rep who represents at least one customer with credit limit of $10,000.00
  10. For each order placed on October 21, 2007 list the order number, part number, part description, and item class for each part ordered

Consistency notes...

  • Nota Bene Premiere Database uses all Upper-Case letters for both table and field names.'
  • Premiere Database is used in both the book and the corresponding book assignments.
  • Fruit database tables are all lower-case letters. Fruit used medial caps, for table names consisting of two words, 2nd words start with capital letters.
  • Premiere is using underscores to separate multi-word table or field names.
  • Function names and arguments are lower case.
  • all filenames for book start with p then page number then .sql

checklist...

  • Read chapter 1
  • Hand write the answers to the 10 updated questions extracted from page 21.
  • Take chapter 1 blackboard quiz
  • Take assignment one blackboard quiz
  • Assignment one blackboard quiz has all SQL queries for submitting p21.sql, if you can submit p21.sql or wait until you cover chapter 3.

Chapter 2 p58.sql

submit p58.sql (7 Points) Read chapter 2, use one of your Databases for fruit (such as DBusername) and other database for Premiere (such as DB1username. Once you have selected your premiere database, delete all existing tables and use PHPMyAdmin import tab, (aka Import Tab, premiere → premiereCreate.sql). You can also download the create script at /home/premiere/public_html/premiereCreate.sql (Right^Click to Save), and then import your local copy using PHPMyAdmin. It is also advantageous to use the PHPMyAdmin designer tab to create a graphic schema. We have an existing schema at http://cim.saddleback.edu/~premiere. After you have created the premiere database, submit p58.sql consisting of these seven Queries...

1) Display names of all the premiere database tables;
2) Display the number of customers you have.
3) List the contents of the CUSTOMER table.
4) Describe the REP table.
5) List the contents of the ORDERS table.
6) List contents of REP table, sorted by highest commission first.
7) Display customer name with highest credit limit, hint select customer_name, order by, limit 1;

You should probably use PHPMyAdmin to help you create the queries, especially the sorted ones.

checklist

Chapter 3 p87.sql

Read chapter 3, submit p87.sql

For p87.sql write queries for this five comments and write comments for the second 5 queries...

  1. #Display the first five rows in ORDER_LINE table.
  2. # Display all your customer names along with their city and state.
  3. #How many salesman do you have?
  4. # Display the contents of PART Table
  5. # Describe the PART table
  6. select * from PART order by PRICE;
  7. select sum( NUM_ORDERED*QUOTED_PRICE) from ORDER_LINE;
  8. select max( Price ) from PART;
  9. select r.LAST_NAME, Customer_name, balance, credit_limit
    from CUSTOMER as c, REP as r where c.REP_NUM = r.REP_NUM;
  10. select Order_num, order_date from ORDERS
    where CUSTOMER_NUM in (select CUSTOMER_NUM from CUSTOMER
    where REP_NUM= 65);

You can keep submitting until you have 10/10, if you don't fix one query at a time

checklist

Chapter 4 p125.sql

Read Chapter 4; submit p125.sql. (21 Points) Write MySQL commands to solve questions 1..21 on page 125. Proceed each command with a comment specifying the question number.

on Question 7 make sure you include both end points 10 and 25 and do this only one way.

Hint on question 20, you need to do a group by rep number right after the from table statement and then use a having clause with sum( balance ). Note the having clause enables the group by clause to be used as a where conditional, in this case sum(balance) refers to the sum of the balance relative to the group by REP_NUM. To sort the final output, just end the query with order by REP_NUM.

checklist

Chapter 5 p157.sql

Read Chapter 5; Chapter 5 on multiple tables is one of the hardest chapters; submit p157.sql, (20 Points) this consists of all Premiere Database queries, questions 1..20 pages 157-158, the following questions have further clarification...
  • Question 5 on all sub-queries you should return only one column, returning multiple columns is often logically incorrect. With the current version of mariaDB this mistake is causing both PHPMyAdmin and submit to hang. You should be doing all initial testing in PHPMyAdmin, submit is for submitting not debugging.
  • Question 6 list customer number and customer name for all customers with active orders that were not placed on 2007-10-21.
  • Question 8 the sort order becomes order by class, ORDERS.order_num and then ORDER_LINE.part_num;
  • Question 9, find rep number, rep last name, and rep first name, of reps who represent a customer with credit limit of exactly 5000.
  • Question 11 you may need to add order by CUSTOMER_NUM DESC.
  • Question 12 # hint you will need to combine the part table with itself, look for the matching classes and display parts number in ascending order; Sort the output by the first part_num table, then by the second part_num table, You are displaying PART_NUM, DESCRIPTION from first table, then PART_NUM, DESCRIPTION, and CLASS from second table. If still stuck, reread the section "Joining a Table to Itself" pages 140-141 and pay special attention to the Q&A sidebar on page 141.
  • Question 13, make sure you include the single quote.
  • Question 15 order by order_num ASC; Hint put select after union in parentheses, then add order by clause
  • Question 16 MySQL doesn't have the intersect operator just use an and in the where clause. You can also consider using or having.
  • Questions 20 order by part number, then by order number both in ascending order.
  • Preface each MySQL command with the question number comment line.

Hints Do not even attempt to try to join more than three tables, use sub queries first to determine customer_num from customer_name, and part_num from description.

checklist

  • read chapter 5
  • take blackboard chapter 5 quiz
  • submit p157.sql
  • Verify your quiz grades on blackboard by clicking quiz Grades button

Chapter 6 p177.sql

Chapter 6 is relatively easy; submit p177.sql; write a SQL query for questions 1-10; Question 8 is two queries, 8 and 8b; Also added four display content of Table:NONAPPLIANCE queries, 2a, 5a, 7a and 9a. Note #2a, #5a, #7a, #9a and #8b are the five additional queries added to this assignment, The final Query list is...
  1. # 1 create table 'NONAPPLIANCE' don't prefix table name 'NONAPPLIANCE' with your database - table fields are PART_NUM, DESCRIPTION, ON_HAND, CLASS and PRICE.
  2. # 2 insert into NONAPPLIANCE all items that are not class 'AP'; For this one you need to use insert select command., Nota Bene I cannot check 1 and 2, they will pass automatically, but #2a will fail, if 1 or 2 are wrong make sure they are working.
  3. #2a Display contents of NONAPPLIANCE sort by ascending Price
  4. #3 change description of PART_NUM AT94 to Deluxe Iron
  5. #4 increase price of all items CLASS SG by 2%
  6. #5 add Part number TL92 description Trimmer, units on hand 11, class HW, price 29.95
  7. # 5a display contents of NONAPPLIANCE Table
  8. # 6 delete every part in NONAPPLIANCE of class SG
  9. # 7 in NONAPPLIANCE change PART_NUM FD21 to CLASS NULL
  10. #7a display contents of NONAPPLIANCE Table
  11. # 8 Add new last Column ON_HAND_VALUE seven digit number with 2 decimal points to NONAPPLIANCE table
  12. # 8b set all values of column ON_HAND_VALUE to ON_HAND*PRICE in table:NONAPPLIANCE
  13. # 9 in NONAPPLIANCE table increase column DESCRIPTION to 30 characters
  14. # 9a display contents of NONAPPLIANCE Table
  15. # 10 Remove NONAPPLIANCE Table

checklist

  • read chapter 6
  • take blackboard chapter 6 quiz
  • submit p177.sql
  • Verify all grades for submit, 2nd row is total possible points for each assignment (note pmaReport is maintained in my personal spreadsheet)
    tutorial intermediate select pmaIntro pmaView pmaReset pmaTrigger Report
    10 15 11 10 15 12 15 10
     
    Book Page: p21 p58 p87 p125 p157 p177
    Possible Points: 10 7 10 21 20 15
    Possible assignment points 98 + 83 = 181 (you can complete extra)

  • Consider completing the extra credit assignments

Extra Credit

submit - casinoNoJoin.sql, Details (i.e., creation scripts, drop table scripts, graphic schema, & data tables ) about the Casino Database are at http://cim.saddleback.edu/~premiere. This assignment can be completed as extra credit, even before you begin the book, but first complete the pre-book introductory fruit assignments. As the name casinoNoJoin.sql implies, you don't join tables to complete the queries. You get 1 bonus point for every 4 correct queries.

Chapter 7 Database Administration and Chapter 8 MySQL Special Topics Are Extra Credit;

For your person gain, can look into MySQL Admin Tools.