SQL database paper - Essay Example

Comments (0) Cite this document
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…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.8% of users find it useful
SQL database paper
Read TextPreview

Extract of sample "SQL database paper"

Download file to see previous pages 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 ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“SQL database paper Essay Example | Topics and Well Written Essays - 750 words”, n.d.)
SQL database paper Essay Example | Topics and Well Written Essays - 750 words. Retrieved from https://studentshare.org/logic-programming/1656655-sql-database-paper
(SQL Database Paper Essay Example | Topics and Well Written Essays - 750 Words)
SQL Database Paper Essay Example | Topics and Well Written Essays - 750 Words. https://studentshare.org/logic-programming/1656655-sql-database-paper.
“SQL Database Paper Essay Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/logic-programming/1656655-sql-database-paper.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF SQL database paper

Paper - What is a Database

...? Databases are widely used in web-sites and internal networks. Originally developed in the 1960's, a database is an application that stores 'data' or 'information' [Rob and Coronel 4]. The components needed, are a database application like MYSQL, or Microsoft's Access, a storage mechanism which is usually a file server or network server such as APACHE or Microsoft IIS or Windows NT. Thus, a database consists of both software and hardware. Generally speaking, databases are comprised of 'tables' full of 'fields'. For example, an online store would have in all likelihood, a database with a minimum of two tables consisting of different fields. As an example of the business use of a database, an online store is a common one, and E-bay... is a...
2 Pages(500 words)Essay

Lanchester Liners Hospitality Database, SQL

...); CREATE TABLE PORTEVENT ( portId Varchar(4) NOT NULL, eventId Varchar(8) NOT NULL); Defining Primary Key: ALTER TABLE SHIP ADD CONSTRAINT pk_ship PRIMARY KEY(shipNo); ALTER TABLE EVENT ADD CONSTRAINT pk_event PRIMARY KEY(eventId); ALTER TABLE PORT ADD CONSTRAINT pk_port PRIMARY KEY(portId); ALTER TABLE SHIPPORT ADD CONSTRAINT pk_shipport PRIMARY KEY(shipNo,portId); ALTER TABLE PORTEVENT ADD CONSTRAINT pk_portevent PRIMARY KEY(portId,eventId); b) Database Population Database is populated with the given information using the below SQL INSERT Statements: Populating SHIP table: INSERT ALL INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed)...
5 Pages(1250 words)Essay

SQL Queries

...implemented database a student may not be employed and on a placement at the same point in time. However in such a database it is still possible for a student to secure employment before they have completed their placement (i.e. having a starting date for employment while still on placement). Create a query that lists all such occurrences. SELECT * FROM Student, Employment, Placement WHERE Student.stu_no=Employment.stu_no And Student.stu_no=Placement.stu_no And Employment.emp_date Between Placement.pl_fdate And Placement.pl_tdate; Description: I have selected and joined Student, Employment, Placement tables and then have filtered record whose employment date is between placement from and to...
3 Pages(750 words)Essay

Database paper

... between objects is one of the major strengths of Oracle. Linking the data in multiple tables is made very easy with its help. It enables to define relationships between the tables when data is stored in two or more tables. Data is represented in tables with values in columns within rows (Craig, 2008). Oracle generally supports three data types: Transient data i.e. data that lasts only for the working of a single program. Stable data i.e. recoverable data that is flexible to failure. Persistent data i.e. accessible further than the process that creates it. In oracle, persistency is made possible by all data stored in tables. SQL Operations in Oracle Data in an Oracle database is accesses by all programs and users with the help... of...
7 Pages(1750 words)Essay

Ch07_AviaCo database. SQL

...1. Write the SQL that will list the values for the first four attributes in the CHARTER table. SELECT CHAR_TRIP, CHAR_ AC_NUMBER, CHAR_DESTINATION FROM CHARTER Output: 2. Using the contents of the CHARTER table, write the SQL query that will produce the output shown in Figure P7.2. Note that the output is limited to selected attributes for aircraft number 2778V. SELECT CHAR_DATE, AC_NUMBER, CHAR_DESTINATION, CHAR_DISTANCE, CHAR_HOURS_FLOWN FROM CHARTER WHERE AC_NUMBER = 2778V Output: 3. Create the SQL query that will produce a list of customers who have an unpaid balance. The required output is shown in Figure P7.11. Note that the balances are listed in descending order. SELECT CUS_LNAME,...
2 Pages(500 words)Assignment

Advanced SQL Queries for the Pine Valley Furniture Company Database

...Advanced SQL Queries for the Pine Valley Furniture Company Database Question 1: What are the IDs for all orders that include furniture produced by the product line 1? SELECT ORDER_t.Order_ID, PRODUCT_LINE_t.Product_Line_ID FROM ORDER_t, PRODUCT_LINE_t WHERE (((PRODUCT_LINE_t.Product_Line_ID)=1)); In order to make this query, we need to know which entities or tables we will query. We need the IDs of all the orders that were made on all the furniture processed by product line one. The most important table in this case is the ORDER table, which we know as ORDER_t. The field from this table that identifies the orders for us is the Order_ID. Given, we need the other table, which has information on product...
2 Pages(500 words)Term Paper

SQL&Security

...SQL and Security Answers to the assignment SQL Injection is a form of database attack where the attacker attempts to insert amalicious code into non validated input. The attacker tries to get the database to dump its contents. A sample is provided below: Var TrainCity; Traincity – Request from (‘TrainCity’); Var sql = “select * from OrderTable where TrainCity = ‘”+ TrainCity +”’”’ If the user requests the city table, the query will drop all the data in the city table. The technique used here is that the attacker will pose the query to the database about the table TrainCity. When the database responds to the query it will drop the table with the entries. This table will be dropped to the attacker, and he will have access... to the...
2 Pages(500 words)Assignment

SQL/PL Database project

...Yours PL/SQL Project Row Type: The %ROWTYPE is used to specify the field of data types taken from columns of the views or tables. The use of the %Row Type is illustrated in the following code (McLaughlin and Harper 34). For example, Triggers: Triggers in PL/SQL are the special stored programs which are triggered by the use of events for the given program. 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 PL/SQL the trigger is a thing that appears in...
1 Pages(250 words)Essay

Database design and SQL Light database creation

...Database Schema Sarita Gogan Grand Canyon HIM-650 Health Care Data Management February 20, Database Schema for a health care clinic The entities and relationships of health care clinic are indicated below together with their relationship; Table 1 : Entities, Attributes and their Relationships Entity Attributes Relationship Deleted_Date Health Care Center Name, address, location Attends to patients Patients Patient number, first name, last name, phone, next of kin, address Patients report in the clinic Appointments Patient number, date, time , appointment number Patients are allocated appointments Prescriptions Patient number ,medicine ,description ,treatment ID Pharmacists give medicine to the patients after being attended... to the...
3 Pages(750 words)Essay

NORMALIZATION AND SQL DDL STATEMENTS

...Normalization and SQL DDL ments By: First Last 8th December Database from Module 3 The database before normalization is as follows. Figure 1 Database before Normalization Tables The six tables forming the database have the following structure: Customer (num, name, address) Employee (num, name, city, state, emp_status*, emp_salary, emp_hiredate) Product (num, name, price) Invoice (num, customer_num*, emp_num*) Order (invoice_num*, product_num*) Emp_Job_Status (emp_status, emp_num*) 1NF Some of the database tables (Customer, Product, Invoice) are in their 1NF as the data in each field is atomic and has unique name, there is no data...
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 SQL database paper for FREE!

Contact Us