Project Evaluation Assignment Example | Topics and Well Written Essays - 1500 words

Project Evaluation - Assignment Example The document also summarises the theories and concepts learnt in the unit, how these theories influenced my work, example/case study of a successful IT project and its comparison with the developed database. Lastly, the document includes the impact of these lessons on my future work, and what I would do differently along with its rationale. Database of Local Recruitment Agency A local recruitment agency requested to have a database in order to store their business information and access the information in the form of reports. The agency deals with the information of customers (job applicants), jobs (currently available and archived) and tracks contact between customers. In order to fulfil the requirement of the agency, I have developed a database in Microsoft Access 2007. As mentioned in the (previous) assignment, the agency has the following requirements: i. A database to be developed in Microsoft Access that is able to store, retrieve and update the information regarding customers, jobs and track contacts between customers. ii. The agency should be able to add new customers, jobs and their information or details in the database through a form (separate for each) of MS database Access. iii. The agency wants several reports to be produced from the database; however, they specified only three reports that include the customer list; jobs list grouped by job type and the report showing contacts and track follow up. iv. The database tables should be populated with data of at-least 20 customers, 10 jobs and 20 contacts. To fulfil the requirements of the agency, I have developed a database in MS Access 2007 that has four tables, which include tblCustomer, tbljobs, tblContact, and tblJobType. The agency can store all the relevant information in these tables (requirement â€Å"i" fulfilled). I have developed three forms to add/update new customers and jobs along with their details (requirement â€Å"ii" fulfilled). I have developed three specified reports that show t he customer list, jobs list and contact group by the customer (requirement â€Å"iii" fulfilled). I have populated the database with required data in the respective table (requirement â€Å"iv" fulfilled). Features of a Smart Database The developed database should also be evaluated in terms of the characteristics of a high quality database as given below: Accuracy The database is considered accurate if the values stored in the fields of the database are correct. After developing, the database for the agency presumes that the information that is input into a database is faultless as well as accurate. Completeness The end user (agency) of the database has to be aware of the information to be provided to the developer(s) for the development of the database, as if they provide less or inaccurate information, the developed database would definitely be useless and inaccurate. In our case, the information of the customer has to be complete in every aspect, for example the customer profil e, education and experience etc. is missing in the developed database, which has not been asked by the agency. Consistency The consistency is as important as the accuracy and completeness of a database. As in our case, the database is considered to be consistent as we have stored the information/data of one item in a single field only. Uniqueness The data in one field must represent