StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Fernando's skate shop Database - Essay Example

Cite this document
Summary
The RDBMS used is Microsoft Access 2007. The database design comprises of 6 tables and with input forms. The database is capable of storing complete information of the…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.4% of users find it useful
Fernandos skate shop Database
Read Text Preview

Extract of sample "Fernando's skate shop Database"

Lanea Hall American InterContinental ITCO231 Individual 4 May In this paper the complete design and implementation of database for Fernando’s Skate Shop is discussed. The RDBMS used is Microsoft Access 2007. The database design comprises of 6 tables and with input forms. The database is capable of storing complete information of the daily business at the shop. This database can be useful for futuristic evaluation of business and for launching promotions by figuring out the sales volume and regular customers.

Introduction:This report describes the features and specifications of the database design formulated for a scenario named “Fernando’s Skate Shop”. This design is implemented using MS-Access 2007. The database design comprises of six tables. The description of tables is given in Table 1.1.List of tables in the database. Table 1.1CustomersThis table contains the detailed information about the customers and acts as a master table for DailyOrders.ProductsThis table contains the information about the products that the shop offers for sale.

It has a foreign key connected to the ProductTypes. This also acts as a master table for DailyOrdersProductTypesThis table contains the categories of Products. Like there are multiple SKATEBORDS listed under different names and with different specs given in the Products table. DailyOrdersThis table records daily transaction of the shop with date and other details. It has foreign keys from Customers and Products tables. SupplierThis table contains detailed information about the Suppliers and acts as a master table for the Purchases.

PurchaseRecordsThis table records date wise transaction of purchases of raw material that is needed to manufacture the skateboards and accessories.The Database Design and Relationships:The database design and the respective relationships are depicted through Figure 1.1. This image shows the implemented entity relationship diagram. The referential integrity is enforced with cascade update and cascade delete. All the relationships are of one – many type. Figure 1.1. The Entity Relationship Diagram for Fernandos Skate Shop DatabaseRationale:These tables are designed through standard normalization process.

In the first normal form the possible fields are created through splitting the bigger fields. Like Complete address is decomposed into Address, City, State and Zip fields. In the second normal form the tables are decomposed to curb redundancy. Like the table “ProductTypes” was extracted out from the table “Products” to maintain the storage space and avoid redundancy in data. The 3rd NF is achieved through the introduction of appropriate relationships through the inclusion of foreign keys.

The respective Primary Keys and Foreign Keys are highlighted in Figure 1.1The Learning OutcomesFollowing are the things that are learnt through this exercise, Identification of possible fields from a given scenario.Filtering out the useful fields.Normalization up to 3NF and establishment of relationships between tables.Implementation of database design by creating tables and fields in MS Access 2007.ReferencesNews-Genie , Initials. (2010, September 09). How to create a new database from scratch in Microsoft access [Online Forum Comment].

Retrieved from http://techgenie.com/latest/how-to-create-a-new-database-from-scratch-in-microsoft-access/Manzo, J.M. (2008). Microsoft office access 2007 in business. United States of America,: Pearson Education, Inc.dbTools Software, Initials. (2001-2011). dbtools software. Retrieved from http://www.dbtools.com.br/EN/dbmanagerpro/features.phpAngeli, E., Wagner, J., Lawrick, E., Moore, K., Anderson, M., Soderland, L., & Brizee, A. (2010, May 5). General format. Retrieved from http://owl.english.purdue.edu/owl/resource/560/01/

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Fernando's skate shop Database Essay Example | Topics and Well Written Essays - 500 words”, n.d.)
Fernando's skate shop Database Essay Example | Topics and Well Written Essays - 500 words. Retrieved from https://studentshare.org/miscellaneous/1577555-fernandos-skate-shop-database
(Fernando'S Skate Shop Database Essay Example | Topics and Well Written Essays - 500 Words)
Fernando'S Skate Shop Database Essay Example | Topics and Well Written Essays - 500 Words. https://studentshare.org/miscellaneous/1577555-fernandos-skate-shop-database.
“Fernando'S Skate Shop Database Essay Example | Topics and Well Written Essays - 500 Words”, n.d. https://studentshare.org/miscellaneous/1577555-fernandos-skate-shop-database.
  • Cited: 0 times

CHECK THESE SAMPLES OF Fernando's skate shop Database

Market and Bank Financial Lending Systems

Since the economic explosion of the1990's, a lot has changed in the way the American economy has been developing.... Although due to the recent war and transfer of power in the World Bank, many credit institutions are thriving.... After approximately 2002, people began to spend the money they had saved up from 2000, and are once again beginning to freely spend it everywhere....
15 Pages (3750 words) Essay

Nutritional Quality of Rapeseed Oil and Health Benefits of Omega Fatty Acids

The fatty acids decrease the bad cholesterol and triglyceride levels and thus decrease the risk of coronary artery disease.... One of the sources of omega fatty… In this essay, the nutritional quality of rapeseed oil and the health benefits of omega fatty acids will be discussed through review of appropriate literature pertaining to the topic. Rapeseed or Brassica napus belongs to the family Brassicaceae to which The plant bears yellow flowers....
9 Pages (2250 words) Essay

Specifications of the Database Tables

Moreover the queries are also implemented on the finalized complete design of database for fernando's skate shop is discussed.... This database can be useful for futuristic evaluation of Lanea Hall American InterContinental ITCO231 Individual 4 May In this paper the field specifications for the database for fernando's skate shop are discussed.... Moreover the queries are also implemented on the finalized complete design of database for fernando's skate shop is discussed....
2 Pages (500 words) Essay

Database security issues

However, with the growth in database systems' demand, security issues concerning the safety of… This paper seeks to discuss some of the database security issues that are threaten to compromise the information stored by organizations.... There has been a rapid growth uptake of cloud computing and hence database systems that are web The paper analyzes security issues concerning both web based and traditional databases.... database inference is a security issue that multi level databases are prone to....
5 Pages (1250 words) Research Paper

Research Vignettes and Theories of Treatment

This research paper describes research vignettes and theories of treatment.... This paper analyses seven individual cases and their difficulties that are important to notice.... it outlines theories that are starting place for new counselors or social workers because they can help them to identify some of the challenges that people face in our society....
18 Pages (4500 words) Research Paper

Potential Threats to the Database

This research will begin with the statement that a database is a collection of interrelated files.... Presently all the corporations run their business through the database technology.... hellip; This paper presents a detailed analysis of the potential threats to the database as well as ways of ensuring database security.... In this scenario, a threat is some kind of situation that can badly affect the database system and the data inside it....
5 Pages (1250 words) Case Study

Angolas Tourism Infrastructure Development

The research focuses on models that will ensure Angola succeeds in the future development of their tourism infrastructure.... Current economic capacity will ensure the research sets future goals based on the country's capacity.... Various players in the industry will be used to recommend a way forward… There exist a relationship between infrastructure and the tourism development....
8 Pages (2000 words) Research Paper

Cloud Storage and Bad Model in Terms of Security and Privacy

igure 1 above shows how data from computers and other mobile devices are stored externally in the database storage.... This coursework "Cloud Storage and Bad Model in Terms of Security and Privacy" describes Cloud storage is the way forward for many organizations, but many offer a bad model in terms of security and privacy....
10 Pages (2500 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us