Task P3.1 Database Design of Computer Sales

Detail level implementation of SSADM for Computer Choice is giving in Task P2.1 and included all the life cycle diagram, explanation for database design for the Computer Choice

  

 Task P3.2  Computer Choice Database snapshots

 

Table and forms are created using MS-Access 2007 for the Computer Choice

Task P3.3 Methods of improvement

Evaluation effectiveness of the database solution is done and database physical structure can be enhance to support high performance by using Hist, Indexing and tuning for the Computer Choice database solution and will help in future when data will be huge in database

 

The effective database management includes the services as follows: 

Building and Expanding 

In the Building and Expanding Process, the RPO firm verifies and searches the existing data for most recent data. The RPO firms then codes the entire data so that the organisation can easily retrieve the information as per their needs. Moreover, with this service you can also insert extra information for an existing desk or else you can create a new desk. 

Cleaning-up 

The Cleaning-up Process is very effective and helpful for every organisation; it keeps the data updated and refreshed all the time. The Cleaning-up Process involves deletion of inaccurate or inactive records; merging of duplicate entries; creating E-mails using organisations E-mail formats; separating inoperative companies or candidates; updating database with the latest information; and more. 

Daily updating 

The Daily Updating Process involves the analysis of information provided by an organisation. In this process, the recruitment process outsourcing firm provides updated information to the organisation, about candidates, clients/customers, schedules client call, and arranges an interview for an applicant. 

Task P3.4  Details of diagrams

 

All the diagram and reference of that is present with above tasks such as DFD, ERD, Normalisation and table. 

 Conclusion

 

It include task 3.1, 3.2, 3.3, 3.4 i.e  database developmental cycle,  different phases of database development methodology to develop database solution for the Computer Choice given data set.  fully functional database (containing at least four inter-relational tables) including user interface i.e. need to create tables, forms using MS-Access 2007 for the Computer Choice.

To get the complete article , visit Database Development Assignment Help.