Task 2 Due date – 21/1/2017 Content needed: Full analysis a. Background full explained b. Current system – hierarchy diagram c. Interviews + summary d. Problem with the current system e. Who are the users f. User requirement g. Data dictionary h. Literature review software i. Data Source and destination j. Hardware required Design Hand drawn design for interface Normalisation ERD diagram Test plan Items No Items Description Expected result Actual result 1 Date <21/1/2016 >31/4/6016 Check that transaction took place between these dates Implementation Database completed Screen shot and full explanation( only for database) Queries(10) – base on user requirement + complex queries Testing Test plan Item 1 Screen shot + queries + output Test all queries Literature review: Explain Different type of software And compare them together C++ and Java For example and u can add any think suitable…like platform for Java Writ like long article about my proposal 1-What is the sql? 2-What is the Microsoft access? 3-comper them ??? 4-what is the oracle ? 5-what is the xampp? 6-what is the my sql?? 7-what is the c++ and java ?? 8-comper them?? 9-what is the bluej and eclips and netbeens ??? 10-comper them 11-which one do you prefer to use ?? Employee Data types Field size Description Validation Rule Empl_name varchar 25 This will hold all the name of the employee for example: Mantee vasanthakumaran Empl_age int Empl_DOb Data Dictionary Data source Items Source Destination Employee details Manager -Store details on database - retrieve staff details -delete details -Add new employee details Normalisation UNF 1NF (1) Table must be atomic – (2) Remove repeating group – (3) Identify the primary key 2NF Must satisfy 1NF Must remove partial key dependency. Identity the primary key, composite, foreign key 3NF Must satisfy 2ND Must be full key dependency Identify keys ERD diagram More Information Analysis Background of company Interview – face to face (provide summary) Questionnaire Study books or observation – provide the summary Diagram Current systems – problem Proposed solution User requirements • Functional requirements • Non – functional requirements • Business requirement • My system has to be robust • My system should load table as required • The system should have buttons such as save, delete, print and add record • The local printer must be connected to the system. • List all customers show name start with “A*” • List all customer who ordered a duvet and a cover on 31/12/2016 and paid by card • The system will have menu such as … • Who are the users of the system Data Dictionary Data source and destination Hardware Software – Literature review Normalisation ERD and relationship Design Overall structure of the systems Diagram - Hand drawn design – rough and neat copy After rough copy – show to user and get feedback – summary , neat copy Diagram Class diagram Use case diagram Collaboration State diagram Activity diagram (With Explanation) Test plan Items Description Expected Data Actual data 1 List all customers whose DOB =30/2/200 Implementation Database Create table customer( Cust_id int(3)); (need to show for each table have been created along with screen of the tables Insert into customer(Cust_id) Values(234) ( Queries Testing Items Description Expected Data Actual data 1 List all customers whose DOB =30/2/200 Item 1 - List all customers dob = 30/2/2107 User manual Evaluation Reference Biblography