SQL database paper Essay Example | Topics and Well Written Essays - 750 words

SQL informationbase paper - Essay ExampleThe customerID field is a unique realm because each customer will have their unique customerID thus the reason for its use as the particular key. The newly go intod bows allow us to have several booked charms associated with a customer thus increase 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 give and the number of persons in the tour. Therefore, the structure will be able to show the customer in encase 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 designate to. The conceptual model can be used to represent the data above.To make the table2NF compliant we introd uce 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 depart would be a Data Modelling Language (DML) innovation. 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 stamp down to sales information, this trigger would be identified as for each statement type and would add data set for the