Information Technology > EXAM > C170 PROJECT 2017 version (All)
C170 PROJECT 2017 version
Document Content and Description Below
Highlighted fields will form a Composite primary key. City State and Zip were separated And are now atomic No duplicate data, each of the above tables has a Primary Key, and a key (foreign) that can ... refer to another table in the group. DONUT TABLE DONUT_ID INT (pk) DONUT_NAME VARCHAR (100) DONUT_DESCRIPTION VARCHAR (255) UNIT_PRICE DECIMAL (10,2) Each table has a primary key which can refer to another one of the tables in this group.CUSTOMER_ID INT (pk) LAST_NAME VARCHAR (30) FIRST_NAME VARCHAR (30) STREET_ADDRESS VARCHAR (100) APT INT, CITY VARCHAR (30) STATE VARCHAR (30) ZIP_CODE INT HOME_PHONE VARCHAR (20) MOBILE_PHONE VARCHAR (20) OTHER_PHONE VARCHAR (20) CONTINUED............. [Show More]
Last updated: 3 years ago
Preview 1 out of 11 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$8.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Apr 20, 2022
Number of pages
11
Written in
All
Additional information
This document has been written for:
Uploaded
Apr 20, 2022
Downloads
0
Views
48
