Question: Consider a relational schema with three relation schemas: DRIVER (Dr_license_no, Dr_name, Dr_city, Dr_state), TICKET_TYPE (Ttp_offense, Ttp_fine) and TICKET (Tic_ticket_no, Tic_ticket_date, Tic_dr_license_no, Tic_ttp_offense). Assume that Dr_license_no

Consider a relational schema with three relation schemas: DRIVER (Dr_license_no, Dr_name, Dr_city, Dr_state), TICKET_TYPE (Ttp_offense, Ttp_fine) and TICKET (Tic_ticket_no, Tic_ticket_date, Tic_dr_license_no, Tic_ttp_offense). Assume that Dr_license_no is a character data type of size 7, Dr_name, Dr_city and Ttp_offense are character data types of size 20, Dr_state is a character data type of size 2, Tic_ticket_no is a character data type of size 5, and Ttp_fine is an integer between 15 and 150. Each tuple in the TICKET relation corresponds to a ticket received by a driver for having been issued a specific type of ticket on a given data for committing a given offense. Use SQL/DDL to create a schema of these relations, including the appropriate primary key, integrity (e.g., not null), and foreign key constraints. In addition, include the definition of domains for each of the distinct attribute types?

Step by Step Solution

★★★★★

3.36 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Drop table driver cascade constraints Drop tabletickettypecascade constraints Drop table ti... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

887-CS-DB (2222).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the universal relation schema INVENTORY (Store#, Item, Vendor, Date, Cost, Units, Manager, Price, Sale, Size, Color, Location) and the constraint set F {fd1, fd2, fd3, fd4, fd5, fd6, fd7}...

Consider the relation instance STUDENT (Major, Stu_id, Activity, Name, Phone) a. Identify all multi-valued dependencies in STUDENT. b. Describe insertion, deletion, and update anomalies that...

Consider the schemas for the table people, and the tables students and teachers, which were created under people, in Section 9.3.Give a relational schema in third normal form that represents the same...

PART II - Relational Algebra Queries Consider the relational schema below and answer the next 6 questions. PK stands for primary key, and FK for foreign key. Not all the schema is shown, but you do...

What is the purpose of normalisation ? What problems does normali- sation gets rid of? When is it used? Consider the relational schema R with key ( a, b, c ) and no alternative keys. Below all its...

sql (1) Consider a relational schema R(A, B, C, D, E) and the following set of functional dependencies valid in the schema List all minimal keys valid in the schema. List all derivations of function...

Problem 1. Consider the relational schema R = ABC. Assume that F = {AC, ACB, BAC}. a) Find the cover of F: (i.e., the set of all non-trivial FDs in F+ with a single attribute on the right and the...

Completion Criteria: For the Pass Task to be marked "Complete" nine ( 9 ) sub - tasks must be marked "Correct". Pass 4 a Consider the Relational Schema shown below. It has been created from an ERD...

Consider the relational schema below with primary key constraints as specified. However, the designer forgot to define any foreign keys Product(model PRIMARY KEY, manufacturer, type) PC(model PRIMARY...

Problem 2. Trigger Specification in SQL [50 pts) Consider the relational schema below with primary key constraints as specified. However, the designer forgot to define any foreign keys Product(model...

Suppose the call price is $14.20 and the put price is $9.30 for stock options, where the exercise price is $100, the risk-free interest rate is 5 percent (continuously compounded), and the time to...

Find each resultant vector R. Give R in standardposition. 18.5 mi

BE11.9 (LO 4) Use the information provided in BE11.8. Assume that the recoverable amount of the division is estimated to be HK$750,000. Prepare Waters journal entry, if necessary, to record...

In poker, five cards are selected at random from a full deck of 52. What is the probability that a hand in a poker game contains a pair, two cards of the same face value?

Identify the foreign keys.

Create the ERM.

Create the relational diagram to show the relationship between DIRECTOR and PLAY.

In a sample of 75 Planter's Mixed Nuts, 12 were found to be almonds. (a) Construct a 99 percent confidence interval for the true proportion of almonds. (Use a z-value taken to three decimal places in...

AutoSave O Off) Document3 - Word Search Brandy Majewski BM X File Home Insert Draw Design Layout References Mailings Review View Help Grammarly Share Comments Week 4 Homework = Question 6 of 20 (1...

Simon recently received a credit card with an 18% nominal interest rate. With the card, he purchased an Amazon Kindle for $320. The minimum payment on the card is only $10 per month. a.If Simon makes...