Nobody downloaded yet

Lanchester Liners Hospitality Database, SQL - Essay Example

Comments (0) Cite this document
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER98.3% of users find it useful
Lanchester Liners Hospitality Database, SQL
Read TextPreview

Extract of sample "Lanchester Liners Hospitality Database, SQL"

Download file to see previous pages Lanchester Liners Hospitality Database This report presents a detailed overview of design and Implementation of Hospitality Database for Lanchester Liners for holding information about their ships, the ports visited where hospitality is offered, and any corporate team-building events organised on-board. In addition, the report also offers a detailed discussion on multi-user access to a database including concurrency, locking, security and access control. 1. ...
85,'10/01/1975','Sails') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1893233,'Amsterdam',61000,'05/09/1977','22.5') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1029833,'Aurora',76000,'16/07/1980','24') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1938821,'Black Prince',11209,'25/06/1976','24.5') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(2832911,'Black Watch',28668,'31/12/1981','21') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(9283321,'Dawn Princess',77000,'30/03/1984','21') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3903211,'Galaxy',77713,'21/09/1979','21.5') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1120322,'Genesis',220000,'11/11/1978','22.3') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3829111,'Horizon',46811,'17/03/1975','21.4') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3822211,'Jewel of the Seas',90090,'20/08/1982','25') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values (4833928,'Norwegian Crown',34242,'01/06/1981','22') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3928111,'Norwegian Dawn',92250,'09/02/1978','25') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3920000,'Oceana',77000,'28/07/1982','21') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3029992,'Polynesia',430,'09/05/1972','Sails') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3400049,'Rhapsody',78491,'23/02/1975','22') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(2939222,'Sensation',70367,'31/12/1975','21') INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3992019,'Serenata',133500,'07/11/1974','20.5') SELECT * FROM DUAL; Populating ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Lanchester Liners Hospitality Database, SQL Essay”, n.d.)
Retrieved from
(Lanchester Liners Hospitality Database, SQL Essay)
“Lanchester Liners Hospitality Database, SQL Essay”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Lanchester Liners Hospitality Database, SQL


...?Task a) and b) The ER-Diagram consists of five main entities, ly VISIT, BOOKING, OWNER, DOG, and INVOICE. The relationships can be explained in detail considering their cardinalities, participations and constraints according to the given scenario. CLASS/VISIT and BOOKING A CLASS/VISIT can have several BOOKINGs and a one BOOKING have a single corresponding CLASS/VISIT. Hence a one to many relationship exits between these entities (Marked with 1 and M near the respective entity). A CLASS/VISIT may or may not have booking at a time and it is considered a BOOKING is optional for a CLASS/VISIT and CLASS/VISIT is mandatory for a booking (marked with a circle on BOOKING as the optional side). A class can either have no bookings... a) and b) The...
4 Pages(1000 words)Assignment

Lanchester Community Hospital

...Lanchester Community Hospital - Database Systems of Entity-relationship modelling allows us to model the system we are going to design a database for. This model helps us to present structured data. In order to design an information system, the primary stage is analysis. Entity-relationship modelling allows us to discover entities and the relations between them. This model describes the way the system works and the way data should be structured to be stored in the database. The advantage of using entity-relationship modelling for Lanchester Community Hospital is that it provides an overview of the system which will be...
2 Pages(500 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

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 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 the patients. Treatment Patient number, date, symptoms, diagnosis, treatment ID Patient is treated and details recorded Referrals Patient number, symptoms, description, hospital, date, referral ID In case the clinic is unable to treat a given disease. Diseases Date, symptoms , occurrence, disease ID Diseases treated are recorded in case there is an outbreak CREATE DATABASE database_healthcareclinic CREATE DATABASE my_ healthcareclinic CREATE TABLE table_patient ( CREATE TABLE Patient ( PatientID char(6) not null, FirstName varchar(24) not null, LastName varchar(64) not null, DOB date, PrimaryProviderID char(6), PRIMARY KEY (PatientID) ); INSERT INTO Patient VALUES (000001, James,...
3 Pages(750 words)Essay

SQL database paper

...SQL Database SQL Database Data normalization is the process of strengthening the cohesion between the data attributes of a data model by eliminating (Ambler, 2013). The normalization process will be done in two phases i.e. First normal form (1NF) and second normal form (2NF). The naming convention would be to name the data model tables with descriptive names as follows: salesperson, tourcustomerdata toursold and tourrates. NTITY RELATIONSHIP DIAGRAM 1. IST Normal Form 1nf The goal of conforming the data model into 1NF is to eliminate any repeating attributes. The attributes tours sold repeats itself twice in the initial data model. The first step will form a new...
3 Pages(750 words)Essay


...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 Lanchester Liners Hospitality Database, SQL for FREE!

Contact Us