This can also reduce the overall cost for managing the records that is paper based. This type of database system can be more secured and easy to manage. Because paper based database have limited physical storage space and the records can be very messy. Manually searching throughout the records can take time so is orating every record.
It is also difficult to make a backup of every record page, another copy also means extra storage space needed. The created Gift Shop database application will allow the system to perform the following functions: Add new items to the record. Add a customer details to the record. Add an order details to the record. Update the created record. Remove one or all of the existing record. Produce a report of the above records. The database will be made using a database application (Microsoft Access or similar). It will be running on a PC with Windows 7 Operating System.
A cup copy of the database can be uploaded to dropped. Com. The whole project will begin by 19th of September 2014 and will be functional by May 201 5. Functional Requirements 1 . Add item to the existing record or add new 2. Search the existing items 3. Update an item detail 4. Remove an item Displays item details 5. 6. Add customer details 7. Displays the customers details update customer details 8. 9. Remove a customer record 10. Add payment details 11. Display Staff details 12. Add Order details 13. Update Order details 14. Display Order details 15. Remove Order 16. Non Functional Requirements .
Runs on a PC with Windows 7 Operating System 2. Back up uploads to Dropped 3. Project must be ready by May 2015 Analysis & Design Techniques Computerized shop database system has been replacing paper-based database for the ease of using systems continues to be in demand. This is due to computerized database system that can store a large amount of records efficiently and it is easy and quick to find the record details. It is also easy to add new data and to update or delete a record, and the record can be transferred into another applications which enables the database system o be accessed by one or more person.
The Gift Shop database system project will be created to help the shop keep track of its records. It will contain all necessary records in a single easy to manage system that can run on any computer systems. The database system will be created using with applications like Microsoft Visual Studio or similar applications making it easier to implement and maintain. The Gift Shop system will offer an easy to use interface and also make use of simple commands. The shop doesn’t need any staffs that have high technical qualifications to operate the system.
Because it is fairly simple, further update and maintenance can easily be done to the system. Have researched similar database system over the internet that have a similar database structure as my gift shop database system. Some of these database systems have used generic table names to contain their records. Here are some of the generic tables that other systems have used: ITEMS or PRODUCT tables that contain an item’s details such as its ID, name and price. ORDER or BASKET tables that will contain the order ID, order date and payment details.
It also holds the shipping address, the total cost, account, and will be used as a flag of the processed status of the order CUSTOMER or MEMBER tables that will contain the customer id number, name, address STOCK tables contain the quantity of items available for every item. INVOICE table A similar database system I have researched was the DVD Store  database. The DVD database can store six procedures. The first two procedures can be used during the login phase. If the user is a returning member, Login will be used to retrieve the user’s details in the CUSTOMER’S.
Otherwise, NEW_CUSTOMER can be used if the user wants to create a new row in the CUSTOMERS table. The user also might want to search a DVD by category, actor or title. This Search procedure will be implemented by BROWSE BY TITLE, and so on. Lastly, when the user made his selection, the Purchase stored procedure will be called to complete the transaction. The Gift Shop database will also make use of the similar schema from the DVD Store but will not include the function of customer login and customer accessibility to the whole shop database.
The search function can be implemented to the Gift Shop database but will be limited to Item and customer search only. The shop Amazon Simple DB is a flexible non-relational data store that offloads the work of data base administration. Free from strict requirements of relational database, the Amazon database system is made to offer high availability and flexibility. Like the Gift Shop database it provides efficient methods to access the store and query functions that are attained using a relational database cluster. The same service also allows the user to quickly add record data and easily retrieve or update that data.
The whole database system will be inexpensive because you only pay for the consumed resources. Another identical shop database is the CITY shop that makes use of the standard shop database, all the tables are made in flat-file format. Flat-file format database refers to data records that have no structured relationships. It may contain only basic formatting and have a small fixed number of fields. The shop implements a generic Database Interface that will be used by SQL applications. Their database requires a user authentication data and the user record also has a time stamp for every login.
The customer table, order table and item table is contained in a single file. It is easier to understand than the rotational database but may be inadequate for a database that will be used to contain more data. The whole system was stored in one single spreadsheet which is not the best tool for databases with large number of records or when you need to do a query. Understood that there are database design mistakes made on some database systems. One or two cannot be easily seen or noticed in just one glance at the page. Poor design and planning can be the most common.
This can lead the whole project off course or lose its direction. Ignoring normalization. Normalization of the database system ensures the consistency of the data. Inconsistent data can result malfunctioning in the database for relational database systems. Poor naming standards. Using improper or irrelevant names for a data The lack of data documentation. Not using comments or definitions of data inside the database like table names, column names, their relationship and constraints. Not using secured data integrity. Not using the stores procedure to access data. Building or using generic objects.
Not testing the database or lack of testing. Justification of Techniques used in Analysis & Design For my Analysis and design technique of the Gift Shop database system, I searched some similar shops that were using a similar layout for their system. Firstly was the DVD Store that is using a fairly simple layout. It uses a relational database format that stores every record into one corresponding table. SQL language has been used to allow programmers to Add, edit, remove and create table records. I have looked at the widely used Amazon shop that also uses a flexible database.
Being very simple to use and designed mainly for use with other Amazon web services it has proved to be one of the most effective system that the Gift Shop could follow. The City Shop database also provides records that could be expanded to provide more data input. But being a flat file database it stores all records in a single place making it easier to understand. Because it is listed in one files a simple sorting and searching can be carried out. It doesn’t need a special application to run or store, a standard spreadsheet can be used.
Creating the Gift Shop database software will ease tracking of valuable information and helps users to maintain access to its data. Using a database system will give more advantages than expected to both the client and owner. One benefit is that it can make the business flexible. Updating and accessing the shops data will be easier using various database managers like Office Access. The finished database data (usually a . Mad file) will be uploaded to a client server if the database should be used in multiple systems.
When building the database, a proper name must be used and it must be named in a sensible way: this is for the purpose of clarity when updating the database. Repetition of data must be avoided at all cost. Also the elimination of redundant data can simplify the database coding making it easier to read.