Free

Improving Electronic Store Database Design - Essay Example

Comments (0) Cite this document
Summary
That is to say, in the first normal form, there is no more than one row of data that has a repeating group of information (Date, 2005). …
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.8% of users find it useful
Improving Electronic Store Database Design
Read TextPreview

Extract of sample "Improving Electronic Store Database Design"

Improving Electronic Store Database Design Insert Insert Improving Database Design through Normalization The tables are already in 1, 2, and 3rd Normal Forms. They are as follows:
Customer Table (Customer ID, Customer Name, Address, Residence)
Sales Order Table (Sale ID, Date, Units Sold, Customer ID, Social_Security_Number)
Employees Table (Social_ Security_ Number, First_Name, Last_Name, Address, City, State, Zip_Code, Birth_Date, Full_Time, Part_Time, Salary, Date_Hire)
The tables exist in the three normalization forms because they meet the criteria to existing in those states. That is to say, in the first normal form, there is no more than one row of data that has a repeating group of information (Date, 2005). A different table is created for every set of data that is related as well as identifying every set of related data with a primary key. In the second normal form, sets of values containing multiple records should exist in varied tables. The tables are then related using a foreign key. In third normal form, all fields depend on the primary key otherwise they should be eliminated.
SQL Statements for the tables in Oracle
According to (Kyte, 2010),
CREATE TABLE Employees
( Social_ Security_ Number number(50) NOT NULL,
First_Name varchar2(50) NOT NULL,
Last_Name varchar2(50) NOT NULL,
Address varchar2(50) NOT NULL,
City varchar2(50) NOT NULL,
State varchar2(50) NOT NULL,
Zip_Code varchar2(50) NOT NULL,
Birth_Date Date NOT NULL,
Full_Time varchar2(50) NOT NULL,
Part_Time varchar2(50) NOT NULL,
Salary varchar2(50) NOT NULL,
Date_Hire Date NOT NULL,
CONSTRAINT social_pk PRIMARY KEY (Social_ Security_ Number)
);
CREATE TABLE Customer
(Customer_ID number (10) NOT NULL,
Customer Name varchar2 (50) NOT NULL,
Address varchar2 (50) NOT NULL,
Residence varchar2 (50) NOT NULL,
CONSTRAINT customer_pk PRIMARY KEY (Customer_ID)
);
CREATE TABLE Sales_Order
(Sale_ID number (10) NOT NULL,
Date Name Date (50) NOT NULL,
Units_Sold varchar2 (50) NOT NULL,
Customer_ID number (10) NOT NULL,
Social_Security_Number number (10) NOT NULL,
CONSTRAINT Sales_pk PRIMARY KEY (Sale_ID)
);
SQL Statement to drop the tables in Oracle
DROP TABLE Employees PURGE;
DROP TABLE Customer PURGE;
DROP TABLE Sales_Order PURGE;
The use of PURGE is to ensure that the space covered by the tables are released and completely removed from the recycle bin so that there is no option to recover it.
References
Date, C. (2005). Database in depth. Sebastopol, CA: OReilly.
Kyte, T. (2010). Expert Oracle database architecture. [Berkeley, Calif.]: Apress. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Improving Electronic Store Database Design Essay”, n.d.)
Improving Electronic Store Database Design Essay. Retrieved from https://studentshare.org/information-technology/1700128-improving-electronic-store-database-design
(Improving Electronic Store Database Design Essay)
Improving Electronic Store Database Design Essay. https://studentshare.org/information-technology/1700128-improving-electronic-store-database-design.
“Improving Electronic Store Database Design Essay”, n.d. https://studentshare.org/information-technology/1700128-improving-electronic-store-database-design.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Improving Electronic Store Database Design

Databases

...and services, sales information, customer data and to keep stock records. Yet again, hospitals use their databases to store patient personal details, diagnostic records, treatments given and payment records. Advantages and Disadvantages of Databases According to Beynon-Davies (2004), there are several advantages and disadvantages associated with using databases. Some of the advantages include reduced data management costs, lower data redundancy, increased consistency, higher data integrity, improved data access, and greater independence from application programs (Connolly and Begg 2002). Some of their cons include complexity, difficulty and time...
4 Pages(1000 words)Essay

Retail Store Design

...shelf, easiness to find the product, lighting influence on customer choice of the shops and a mutual comparison of the shops based on the lighting.in both countries. Thus the results obtained clearly established the strong influence of lighting in the design of retail stores. It is observed that the variations in lighting have changed the customer attention on the product locations and have also created preferences on some store by customer. The positive feel created to the customers during their visit to the stores have helped to increase the number of past customers visiting the store and thus improving the business of the company....
11 Pages(2750 words)Essay

Database Design

... below The type of triggers used in this application is under the category of Data Manipulation Triggers as the information in the tables are the ones targeted by the triggers and not the design. Change of Meter to the customer The first trigger for the database is when the meter changes, the system should automatically generate the billing details for the meter to the customer and store it in the Billing Table. The code for the trigger is as follows CREATE TRIGGER Update_Bill AFTER UPDATE OF Cust_MeterID ON TblCustomer FOR TblBilling.Bill_EndDate <= TblMeter.Meter_EndDate TblBilling.Bill_Amount = TblBilling.Bill_Amount + (TblMeter.Meter_Reading * price) NEXT COMIT; END; The aforementioned trigger in Oracle proves that the efficient... Database Design The database design is presented in three stages as identified by Gavin Powell (2005)i. These...
14 Pages(3500 words)Essay

Relational Database Design

...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1... ...
6 Pages(1500 words)Assignment

Database Design & Development

...Relational Database Management System Definition of RDBMS RDBMS can be defined as a set of modules that helps the organization create, maintain database at a single, centralized point. It is a database management system that is based on a popular model of relational model. This model was devised by E. F. Codd. It is a DBMS that manages the data in the form of tables, even the relation that exists between these tables in stored in the form of tables. RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005). All data is held in the form of tables and is described by the use of data values. The data which is found in the...
4 Pages(1000 words)Essay

Database systems analysis & design

...System Database Design Report Table of Contents Introduction 3 System Context 3 Stakeholders 3 Requirement Analysis 4 Requirements 4 2.Business Objects (Entities) 4 Database Design 5 1.ERA Diagram 5 1.1.Entity-Relationship Model (ER Model) 6 1.2.Entity-Attribute Model (EA Model) 7 1.3.Entity-Relationship-Attribute Diagram (ERA Diagram) 8 2.Normalization 9 2.1.Un-normalised Form 9 2.2.First Normal Form (1NF) 10 2.3.Second Normal Form (2NF) 11 2.4.Third Normal Form (3NF) 11 Testing 14 Sample Test Data 14 Test Cases 15 Conclusion 18 Introduction This document demonstrates the concept of normalization while designing the conceptual data model of a University...
12 Pages(3000 words)Assignment

Database Design and Implementation

...Database Design and Implementation Faculty: Department: Module Academic Year: Semester Data investigation and capture 1 of the three websites chosen 1.1.1 http://www.ubid.com This is an online auction site gaining popularity close to that of e-bay. Even though it does not have as much traffic as e-bay, it generates quite a number of sales. The fact that it does not charge listing fee puts it at a greater competitive edge over the similar online purchasing sites. A major pitfall exists in the payment duration; the buyer’s payment can take up to a fortnight since it goes through Ubid which can cause a serious cash flow problem for the new sellers. 1.1.2 http://www.ebid.net/ E-bid auction is one of the...
20 Pages(5000 words)Assignment

Database Design Proposal

...as outlined, the database will enable all the stakeholders of the health facility the convenience to get all they need to know in real-time. Using restricted access, reliability and security of data stored is assured. From analysis of the budget of designing the database, this system is cheaper than traditional filing systems. References Singh, S. (2009). Database Systems: Concepts ,Design & applications. Pearson Education India. University Of Georgia. (2013). What is a Database? Retrieved 2 11, 2013, from University of Georgia : http://www.usg.edu/galileo/skills/unit04/primer04_01.phtml Stubbs, D. F., & Webre, N....
3 Pages(750 words)Article

Principles of Database Design

...Principles of Database Design Principles Of Database Design Disaster Recovery and Business Continuity Plans Business continuity and disaster recovery refer to the contingency plans and measures designed and executed by a business to guarantee operational flexibility in case of any service interruptions. As information technology systems have become the focus of all areas of business, the capacity to reliably and promptly recuperate these systems have become a vital issue in any business. A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention and recovery for the business. At the same time, it retains value system... ...
2 Pages(500 words)Essay

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending... ...
2 Pages(500 words)Essay
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.

Let us find you another Essay on topic Improving Electronic Store Database Design for FREE!

Contact Us