Skip to Main Content
Data Analysis for Database Design, 3rd Edition
book

Data Analysis for Database Design, 3rd Edition

by David Howe
May 2001
Intermediate to advanced content levelIntermediate to advanced
336 pages
14h 36m
English
Butterworth-Heinemann
Content preview from Data Analysis for Database Design, 3rd Edition
CREATE TABLE lamp_table OF lamp
(PRIMARY KEY product_no)
where lamp_table is the name of a table of type lamp.
A structured UDT can inherit the properties of more than one supertype (this is
known as multiple inheritance, as contrasted with single inheritance). Conflicts may
occur in multiple inheritance. For example, a subtype may inherit different attributes
that happen to have the same name. SQL99 has precise rules governing such situations.
A distinct UDT is a much simpler type than a structured UDT. It is essentially a
renamed version of a built-in data type. For example, suppose goods are sold in UK
currency (pounds, pence) and also in US currency ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Quality Engineering in Financial Services

Data Quality Engineering in Financial Services

Brian Buzzelli

Publisher Resources

ISBN: 9780750650861