SQL database paper - Essay Example

Extract of sample
SQL database paper

The customerID field is a unique area because each customer will have their unique customerID thus the reason for its use as the primary key. The newly introduced tables allow us to have several booked tours associated with a customer thus increasing the flexibility of the system. It also reduces the storage space required. The tour1NF tables are added to allow customers to make several orders (“Informix Guide”, 1998).
A table that keeps tours sold and tour customer data, holds, address, customer name, city, zip code state, tour(s) selected, total amount paid and the number of persons in the tour. Therefore, the structure will be able to show the customer in case he/she books more than once.
Data modelling refers the process of examining data-oriented structures, in that you single out entity types into which attributes are assigned to. The conceptual model can be used to represent the data above.
To make the table2NF compliant we introduce the customerID field as the primary key of the customer table and the foreign key of the newly created table in 1NF tours selected table. This makes the table 2NF compliant.
Using the salesperson table that was described earlier the most appropriate trigger would be a Data Modelling Language (DML) trigger. The trigger is initiated every moment the salesperson sales a tour. In the new data model the customer information is subsidiary to sales information, the trigger is identified as “for each statement type” and is an additional data set for the salesperson each time the tour booking triggers the event.
Using the salesperson table described the appropriate trigger would be a Data Manipulation Language (DML) trigger and would be initiated each time a tour operator sells a new tour. Under the new structure in which the client information is subordinate to sales information, this trigger would be identified as “for each statement type” and would add data set for the ...Show more

Summary

The normalization process will be done in two phases i.e. First normal form (1NF) and second normal form (2NF).
The goal of conforming the…
Author : dickinsonzack
SQL database paper essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"SQL database paper"
with a personal 20% discount.
Grab the best paper

Related Essays

Methods for Database Security
Abstract Database security has become one of the most important issues in today’s world of technology. This paper introduces the issue of database security in an organization by introducing the need and importance of database security. This is followed by a description of the main types of security threats that an organization would face, though the list is not conclusive.
10 pages (2500 words) Essay
Database in an Organisation
4 4. Uses of Database Systems in a Health Care Organization 4 5. How Do Organizations Use Database Systems? 6 6. Advantages and Disadvantage of Database Systems 6 7. Conclusion 7 References 8 Abstract Database is a record of important data, which an organization requires to run different business processes and activities.
6 pages (1500 words) Essay
Lanchester Liners Hospitality Database, SQL
5 pages (1250 words) Essay
Database Security for Electronics Ltd
In an organization, databases store information about the client’s details, the financial information, and the details of the human resource and, all the data that may be of significant to the company. All the data that are stored in the database should be secured properly.
8 pages (2000 words) Essay
BLOBs in database
One obvious medium that is used to quickly access and store these electronic documents is the database. Many online and distributed systems require the efficient access of thousands of binary files such as music (the sample files streamed to potential customers), digital signatures, and other documents and videos that generally range in size from 10KB to SMB.
4 pages (1000 words) Essay
Database, SQL
The primary function of a database is not only to store and retrieve data but also to efficiently handle concurrent request for data from
5 pages (1250 words) Essay
SQL/PL Database project
Triggers run between the issuance of a command and database management action is performed. There are five types of the triggers which belong to Oracle database 11g. Triggers are also fired in the response to the event of database. In the
1 pages (250 words) Essay
Database design and SQL Light database creation
It also has a limitation while indicating the relationships among the data entities. This diagram can be highly improved so that it illustrates clearly all the relationships. This can only be achieved through the use of the
3 pages (750 words) Essay
Technical Paper: Database Administrator for Department Store
In designing, the database several necessary steps, procedures and precautions will be considered as the database should be employed to support both the accuracy,
6 pages (1500 words) Essay
Database
This paper will analyze the uses of databases across the healthcare industry and will also discuss different database architectures. A Healthcare database system can be simply defined as the collection of healthcare data having well defined structure and purpose. Scholars
3 pages (750 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT