What normalization is and what role it plays in
the database design process
About the normal forms 1NF, 2NF, 3NF, BCNF,
How normal forms can be transformed from
lower normal forms to higher normal forms
We have already seen examples of column subqueries
performed with the keywords IN and NOT IN.
To find all pet owners:
SELECT FName, LName FROM Employees
WHERE ENo IN
(SELECT ENo FROM Pets);
To find employees who do not own a dog:
Inner Join Review
How can we calculate the grand total that was
paid for all those toys ordered by Quebec
To calculate the total paid for those toys, remember that there is no Line Total column
in the Company2 Details table:
In most tables, there is one
Nam Addres Phone
crucial column that contains
514-999a unique (non-duplicated) C1001 Walte 777
value for each row, known C1002 Jesse 2009
So far, we have seen subqueries that work in three different ways:
1. Scalar subqueries that return a single value which the outer
query uses for comparison purposes:
SELECT FName, LName, Salary FROM Employees WHERE Salar
1 Introduction to PHP
What is PHP
SERVER SIDE SCRIPTING LANGUAGE FOR THE WEB
RUN AND EXECUTE QUERIES
INTERACTIVE WEB PAGES
BASIC KNOWLEDGE OF HTML
YOU NEED XAMPP DOWNLOAD XAMPP
but dont bring in the other attachments
just Apache MYSQL FileZilla Mercur
42 Introduction to Forms and PHP
This what you get when you run/refresh
This is INDEX FILE
This is HANDLER FILE
43 GET and POST
Page . 1
JAC Mike Cooney
Same as get but difference is that your name will not be seen on URL like post does
A modification command does not return a
result (as a query does), but changes the
database in some way.
Three kinds of modifications:
1. Insert a record or records.
2. Delete a record or records.
COURSE OUTLINE DETAIL SHEET
Okay, now how to start all this?
FIRST: Get the book you need it every week. Dont bring it to class, you need to read the chapter at
home. The book will not be needed in class.
SECOND: Prepare for the quiz. The Quiz is on the c
Sunday October 4th 2015
Today there was a customer that was complaining about the inexactitude of a price on an item
she wanted to buy. I went with the product to go see where it was that she had seen that
specific price she thought it should have been, t
How Do You Feel?
Lets start with the here and now: How do you feel?
I mean, how do you really feel?
Could you describe the condition of every part of your body?
Could you report on all muscles, joints, and bones?
Your heart and lungs?
While looking in my computer for possible files when my USB messed up, I
remembered that I put an unfinished version of an exe of my original program on
my google dropbox. Between then and my USB having bugged, I had finished most
of the required steps.
SOME USEFUL SQL STATEMENTS AND MySQL CONSOLE COMMANDS
SHOW FIELDS FROM Employee;
SELECT * FROM Employee;
HELP (or ?)
1. select * from employees where fname like "G%" or lname like "G%" order by hired;
2. select * from employees where dept in ("sl", "it") and iq > 120 order by iq desc;
3. select * from employees where birth like "197%" and dept not in ("ac
1. select dept, sum(salary), avg(salary) from employees group by dept order by sum(salary) desc;
2. select count(birth)/count(eno)* 100 as percentage from employees;
3. select distinct dept, year(hired) from employees where dept in ("IT") order by hired;
Multimedia & Internet Lab # 2
Worth: This lab will count towards the lab portion of your final grade at 5%
Due: October 31, 2014 (by end of day)
Hand in: A zipped folder with all your relevant files onto LEA in the assignment sect
SQL REFERENCES COMMONLY USED OPERATORS Revised 2013-06-13
Grouped by dashed lines into Precedence levels from highest to lowest. Operators with
the same precedence are executed from left to right.
For all these examples assume we are currently on a record
It is a CMS (Content Management System) and a publishing platform for the web. Popular.
Two ways of using WordPress: Online at WordPress.com or download and install onto a server.
WordPress.com: you sign up, you get a site (yourname.wordpress.co