www.StevenAttridge.com

Database Administration

|-----------------------------------------------------------|

Homework Solutions:

• Homework 1
• Homework 2
• Homework 3
• Homework 4
• Homework 5
• Homework 6
• Homework 7
• Homework 8 .txt .html
• Homework 9
• Homework 10 .txt .php

BACK TO TOP

|-----------------------------------------------------------|

Lab 1 Solutions:

• Assignment
• My Solution
• SELECT * FROM faculty ORDER BY name.html
• SELECT * FROM faculty ORDER BY ordnum.html
• CS Faculty Table.xls

BACK TO TOP

|-----------------------------------------------------------|

Lab 2 Solutions:

• Assignment
• Entity Class Choices
• Design Notes
• CS GA Table.xls

HTML Output Results

• nested query 1.html
• nested query 2.html
• select all from faculty order by primary key.html
• select all from faculty.html
• select all from ga order by foreign key.html
• select all from ga order by primary key.html

BACK TO TOP

|-----------------------------------------------------------|

Lab 3 Solutions:

• Assignment
• Design Notes

SQL Script

• Lab 3.sql

HTML Output Results

• 3-1a (table1 ORDER BY PRIMARY KEY).html
• 3-1b (table2 ORDER BY PRIMARY KEY).html
• 3-1c (table3 ORDER BY PRIMARY KEY).html
• 3-2a (nested query1 - MtoM).html
• 3-2b (nested query2 - MtoM).html
• 3-3a (CREATE JOIN VIEW).txt
• 3-3b (query JOIN VIEW).html
• 3-4a (1to0 - 0to1- 1).html
• 3-4b (1to0 - 0to1- 2).html
• 3-4c (1to0 - 0to1- 3).html
• 3-4d (1to0 - 0to1- 4).html

BACK TO TOP

|-----------------------------------------------------------|

Lab 4 Solutions:

• Assignment
• Managing DB Objects
• Normalization Defined
• Design Notes

SQL Scripts

• PrimaryUser.sql
• SecondaryUser.sql

HTML Output Results

• 4-1 (VIEW query).html
• 4-4 (GRANTS to java).html
• 4-5 (SELECT ALL ORDER BY PRIMARY KEY).html
• 4-6 (table INFO_SCHEMA).html
• 4-7 (view INFO_SCHEMA).html
• 4-8a (SHOW INDEX FROM table).html
• 4-8b (SHOW CREATE table).html
• 4-9a (java VIEW query).html
• 4-9b1 (java table query - before UPDATE).html
• 4-9b2 (java table query - after UPDATE).html

BACK TO TOP

|-----------------------------------------------------------|

Lab 5 Solutions:

• Assignment

Web Pages

• GAmenu5.html
• GAconnect5.php
• GAmenu5_css.css
• GAquery5.php
• GAupdate5.html

BACK TO TOP

|-----------------------------------------------------------|

Texts (.PDF):

• PHP and MySQL Web Development [Addison-Wesley, 4e]
• MySQL [Addison-Wesley, 4e]
• Beginning PHP & MySQL [Apress, 3e]
• First PHP & MySQL [OReilly, 2008]
• PHP 6 & MySQL 5 for Dynamic Web Sites
• PHP for the Web [3e]
• PHP Objects, Patterns, & Practice [Apress]
• PHP Solutions Dynamic Web Design Made Easy [FriendsofED]
• Practical Web.2.0 Applications with PHP [Apress-2007]
• Pro PHP Patterns Frameworks Testing & More [2008]

[Note: the texts above are password protected & remain the sole property of their author.]

BACK TO TOP

|-----------------------------------------------------------|