Vht2 task 1 Study guides, Class notes & Summaries

VHT2 TASK 1 Course: Data Management – Applications – C170 Rebekah Midkiff WGU ID # 1st NF 1.a - 1.c 2nd NF Bagel order can contain more than one bagel. The bagel order id inside bagel order line item belongs to one bagel order id. One bagel_id in bagel_order_line item can only have one bagel_id. But the bagel item can be on more than one order. The relation would be M:1 Attributes are assigned in this table by looking ...

VHT2 TASK 1 Course: Data Management – Applications – C170 Rebekah Midkiff WGU ID # 1st NF 1.a - 1.c 2nd NF Bagel order can contain more than one bagel. The bagel order id inside bagel order line item belongs to one bagel order id. One bagel_id in bagel_order_line item can only have one bagel_id. But the bagel item can be on more than one order. The relation would be M:1 Attributes are assigned in this table by looking ...

VHT2 TASK 1 Course: Data Management – Applications – C170 Rebekah Midkiff WGU ID # 1st NF 1.a - 1.c 2nd NF Bagel order can contain more than one bagel. The bagel order id inside bagel order line item belongs to one bagel order id. One bagel_id in bagel_order_line item can only have one bagel_id. But the bagel item can be on more than one order. The relation would be M:1 Attributes are assigned in this table by looking at ...

WGU C170 VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN Course: Data Management – Applications – C170 John Smith Western Governors University Student ID # ######## Nora’s Bagel Bin Database Blueprints First Normal Form (1NF) BAGEL ORDER PK Bagel Order ID PK Bagel ID Order Date First Name Last Name Address 1 Address 2 City State Zip Mobile Phone Delivery Fee Bagel Name Bag...

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN Course: Data Management – Applications – C170 John Smith Western Governors University Student ID # ######## Nora’s Bagel Bin Database Blueprints First Normal Form (1NF) BAGEL ORDER PK Bagel Order ID PK Bagel ID Order Date First Name Last Name Address 1 Address 2 City State Zip Mobile Phone Delivery Fee Bagel Name Bag...

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN Course: Data Management – Applications – C170 John Smith Western Governors University Student ID # ######## Nora’s Bagel Bin Database Blueprints First Normal Form (1NF) BAGEL ORDER PK Bagel Order ID PK Bagel ID Order Date First Name Last Name Address 1 Address 2 City State Zip Mobile Phone Delivery Fee Bagel Name Bagel...

INSERT INTO SUPPLIER (supplier_id, company_name, country, sales_contact_name, email) VALUES(901, 'Britt Co', 'Costa Rica', ‘Kendra Garcia’, ''), (902, 'Dota Coffee', 'Costa Rica', 'Omar Santos', '), (903, 'Quality Beans', 'Colombia', 'Mariano Yepez', ‘'); INSERT INTO COFFEE (coffee_id, shop_id, supplier_id, coffee_name, price_per_pound) VALUES(10, 1322, 901, 'Cafe Monica', 3.00), (11, 912, 902, 'Juan Garcia', 3.00), (12, 112, 903, 'Royal Coffee', 2.00);