Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading content…
Loading…
Transcript

Solid Rock Database

Group 4

Tanashay Cheddesingh

Akeen Williams

Andre Laing

Brandon Chin

BACKGROUND

Solid Rock Lifeco is an Assurance company that offers insurance to the Jamaican populace. Solid Rock wishes to recognize and reward employees who are outstanding performers. The company has decided to offer a few units in an upcoming housing development to a top insurance advisors. Top insurance advisors are those employees who have accumulated the highest number of points in terms of sales for the previous year. To be eligible employee has to be a top advisor and has to earn at least 50,000 points.

Identify the Problem and Find A solution

OUR TASK

The Problem

The business Currently Uses A Manual System for Calculations

The Manual system tends to be time consuming

Is Prone to Frequent error in Calculation

Create a formal employee tracking system that will be able to carry out the following

The Solution

Weekly Sales Report

Stores employee information

Stores information about sale

LIMITATIONS AND IMPROVEMENT

LIMITATIONS AND IMPROVEMENTS

Things that lowered the effectiveness of the database

LIMITATIONS

Limited Size

Size

Any business that uses more than 2GB will discover limitations with MS Access. If you’re a large corporation or department, Access may not be big enough for you.

Corruption

Corruption

For as long as its inception, MS Access has been vulnerable to corruption. Though it’s not likely to occur, the fact that it can (and does) happen makes people untrusting.

Limited Users

Limited Users

With only around 255 concurrent users (open actions), it’s difficult to have many users on the database at once. Access works best for smaller businesses with a handful of users.

IMPROVEMENT

IMPROVEMENT

Size

Size

You can improve performance and application maintainability by splitting your Access database into two databases. The "application" part of your database holds all objects except tables, and is linked to the "data" part that contains the actual tables.

Corruption

Corruption

The best thing to do is work with an Access support company. When you understand how to use the database correctly, the chance for corruption is low.

Limited User

Limited User

Have a specialized team or department that will use the particular database instead of giving the entire company access

CONCLUSION AND RECOMMENDATION

CONCLUSION

AND

RECOMMENDATION

CONCLUSION

Despite the minor limitations faced by the database system, with the proper training, the system can be easily maneuvered and works well in presenting the data requested without the need for complex formulas and calculations.

RECOMMENDATION

A few tips to improve the effectiveness of your database

Relationships

Related tables with one-to-one or one-to-many relationships should implement referential integrity with cascading deletes and/or updates to ensure orphan records are not created. With cascading deletes, the removal of the parent record, automatically deletes the child records in the corresponding table.

Where possible, limit the number of fields returned by a query. This results in faster performance and reduced resource usage.

Queries

Primary key

Ensure that every table in your database have a primary key. This allows your database application to quickly locate specific records. Additionally, you cannot create secondary indexes on a table's fields unless that table has a Primary Key.

Choose the best data types for your fields. By choosing the optimal data type, you can decrease both the disk space used to store data, and the time it takes Access to retrieve, manipulate, and write data. The general guideline is to choose the smallest data type possible to store a particular type of data.

Disk Space

Speed

You can significantly increase the performance of opening tables, forms, and reports that are based on linked tables by having Microsoft Access keep the linked table's database open. To do this, open a Database variable in Visual Basic code using the Open Database method. Keep this variable open as long as your application is running. This forces Access to keep that database open, making access to linked tables much faster.

Learn more about creating dynamic, engaging presentations with Prezi