Small Group N-Tier assignment. (Due 7 October 2008)
Create a website named "CS4790GA1" that allows the user to lookup, insert, update and delete Branch and Staff information.
The website should have a logon screen to validate the user and provide security for the edit pages.
There should be an separate page for editing Branches and Staff Members.
On each of the edit pages provide for inserting new records, deleting records and updating existing records.
- Insertions, updates and deletions into the Staff table must not violate the foreign key staff constraint.
-
Insertions and updates must not violate the primary key constraints for either table.
(Enforce both constraints at the business tier)
Create the website using a 3-tier, disconnected recordset web site.
Each group member or will be assigned to a specific tier.
Download Dreamhome.mdb at http://rbhilton.com/wsucs/cs2550/dreamhome.mdb
| Group | Presentation | Business | Data |
|---|---|---|---|
| 1 | Hyrum |
Daniel |
Brody |
| 2 | Brian |
Tyler |
Ken |
| 3 | Matt |
Jeff |
Michelle |
| 4 | Sam / Bryant |
Kirby |
Brandon |