IT703 2018. Assignment 1 20% of the course mark
Due 09/08/2018
A small CRM database and user front end with secure login.
Business rules
- You need a secure login to access the Customer and Contact Pages
- The Customer page will open on an empty form
- There will be a dropdown or search field on the customer form which will load an existing customer and the contacts for that customer
- When the Add Contact button on the customer form is pressed the Contacts form will open with the company name already filled in
- There will be a dropdown or search field on the contacts form which will load an existing contact
- Title on the contacts form will be filled from the database
Deliverables
- Demonstrate working model 15%
- Screenshots 1%
- Code (HTML, PHP, C# or any other method you choose) 2%
- ERD and DDL code to create the database and tables 2%
Marking Schedule
- Login
- Working 1%
- Secure 2%
- Username/password stored in the database 2%
- Encrypted 1%
Search/Dropdown
- Finds Customers/contacts from the database 2%
- Loads data to the appropriate form 2%
Save Update Remove
- All functions work 1%
Students can explain how the front end interacts with the database 4%