数据库代写: IT703 2018. Assignment 1 CRM database and user front end with secure login

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

1. You need a secure login to access the Customer and Contact Pages
2. The Customer page will open on an empty form
3. There will be a dropdown or search field on the customer form which will load an existing customer and the contacts for that customer
4. When the Add Contact button on the customer form is pressed the Contacts form will open with the company name already filled in
5. There will be a dropdown or search field on the contacts form which will load an existing contact
6. Title on the contacts form will be filled from the database

Deliverables

1. Demonstrate working model 15%
2. Screenshots 1%
3. Code (HTML, PHP, C# or any other method you choose) 2%
4. ERD and DDL code to create the database and tables 2%

Marking Schedule

1. Login
   1. Working 1%
   2. Secure 2%
   3. Username/password stored in the database 2%
   4. Encrypted 1%

Search/Dropdown

1. Finds Customers/contacts from the database 2%
2. Loads data to the appropriate form 2%

Save Update Remove

1. All functions work 1%

Students can explain how the front end interacts with the database 4%