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

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 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?
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Modeling and Database Design

ISBN: 978-1285085258

2nd edition

Authors: Narayan S. Umanath, Richard W. Scammel

Question Posted: