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, 23.06.2019 00:30, lilobekker5219
Knowing that the central portion of link bd has a uniform cross sectional area of 800 mm2 , determine the magnitude of the load p for which the normal stress in link bd is 50 mpa. (hint: link bd is a two-force member.) ans: p = 62.7 kn
Answers: 2
image
Computers and Technology, 23.06.2019 01:30, anggar20
Which tab is used to change the theme of a photo album slide show? a. design b. view c. transitions d. home
Answers: 1
image
Computers and Technology, 23.06.2019 23:30, issacurlyheadka
A. in packet tracer, only the server-pt device can act as a server. desktop or laptop pcs cannot act as a server. based on your studies so far, explain the client-server model.
Answers: 2
image
Computers and Technology, 24.06.2019 01:00, kkruvc
Mastercard managers are motivated to increase (1) the number of individuals who have and use a mastercard credit card, (2) the number of banks and other clents who issue mastercards to customers and/or employees, and (3) the number of locations that accept mastercard payments. discuss how mastercard could use its data warehouse to it expand each of these customer bases.
Answers: 3
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
History, 22.03.2021 17:40
Konu
Mathematics, 22.03.2021 17:40