Computers and Technology
Computers and Technology, 16.10.2020 07:01, vvaallww

1. Define the following database, similar to the example database from Assignment 1: CUSTOMER CID, CName, CPhone) TICKET (CustomerID, CruiseID, TDate) CRUISE (Crib, PortName, CrLength, CrPrice) The customer IDs should be exactly two characters long, and the phone numbers should be exactly seven characters long; you may choose an appropriate maximum length for the customer names. The eruise IDs should be exactly three characters long, and you may choose an appropriate maximum length for the port names. Each cruise length should be a positive integer (i. e., zero is not allowed) with at most two digits, and each cruise price should be a non-negative number (i. e., zero is allowed) with up to four digits to the left of the decimal point and exactly two digits to the right of the decimal point. The ticket dates should be stored as date objects (using the DATE keyword or the to_date function), not just as character strings. Define the primary keys and foreign keys as indicated in the schemas above. (This means that you will have to create CUSTOMER and CRUISE before TICKET.) In order to avoid name conflicts, start your script file with DROP TABLE commands for all three tables (since TICKET contains foreign keys, you will have to drop it first.) Run your script and look at the columns and constraints of each table to verify that they have been created correctly before going on. 2. Populate the CRUISE table with IDs, ports, cruise lengths, and prices for at least three cruises offered by the company. (Choose ports you would be interested in visiting - you can make up the IDs, lengths, and prices.) Then populate the CUSTOMER table with information for yourself and at least three of your friends. (You can make up the IDs and the phone numbers - and even the friends if you'd like.) Look at the data in each table to verify that they have been populated correctly before going on. 3. Next, insert at least five records into the TICKET table. There should be at least one record for each customer, and at least one customer must have two or more records in the TICKET table. Choose your data so that each customer is only booked on one cruise at a time that is, a customer's next cruise cannot start until the previous one has ended. (This particular constraint - ensuring that cruises do not

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 22:00, zay179
What is a distinguishing feature of today’s graphic application software?) graphic applications are used today on a variety of devices, including touch-screen kiosks and mobile phones.
Answers: 3
image
Computers and Technology, 23.06.2019 16:00, lokaranjan5736
Write a grading program for a class with the following grading policies: a. there are two quizzes, each graded on the basis of 10 points. b. there is one midterm exam and one final exam, each graded on the basis of 100 points. c. the final exam counts for 50% of the grade, the midterm counts for 25%, and the two quizzes together count for a total of 25%. (do not forget to normalize the quiz scores. they should be converted to a percentage before they are averaged in.) any grade of 90 or more is an a, any grade of 80 or more (but less than 90) is a b, any grade of 70 or more (but less than 80) is a c, any grade of 60 or more (but less than 70) is a d, and any grade below 60 is an f. the program will read in the student’s scores and output the student’s record, which consists of two quiz and two exam scores as well as the student’s average numeric score for the entire course and final letter grade. define and use a structure for the student reco
Answers: 2
image
Computers and Technology, 24.06.2019 10:10, juliana0122
Scanning the road can be thought of as a
Answers: 2
image
Computers and Technology, 25.06.2019 02:00, lovemykay2355
Software and services are used to conceive, plan, and execute projects in any field. these tools are excellent methods of increasing the probability of successful projects. open source linux project management mind-mapping
Answers: 2
Do you know the correct answer?
1. Define the following database, similar to the example database from Assignment 1: CUSTOMER CID, C...

Questions in other subjects:

Konu
Mathematics, 23.03.2021 18:20
Konu
Mathematics, 23.03.2021 18:20
Konu
Mathematics, 23.03.2021 18:20
Konu
English, 23.03.2021 18:20