B ITM 330 Study Guide - Midterm Guide: Referential Integrity, First Normal Form, Fourth Normal Form

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 330
• Professor: Jakov Crnkovic

Document Summary

In the relational model, many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:n relationships can. Find the pk for the table employee(employee_id, first_name, last_name, phone, Is the table employee(employee_id, first_name, last_name, phone, position_id, Position_description) in: 1nf, 2 nf, 3 nf, 4nf. If the table employee(employee_id, first_name, last_name, phone, position_id, The reason for having a table parts may be: to list prices, to present number of each item on hand, to present current customers, all of the above, only a) and b) To create a price list for a super sales event with 10% discount you will create a ______________ and in the new field sales_price put: _______: table, sales_price:price*. 10, query, sales_price:price*0. 10, query, sales_price:price*0. 90, table, sales_price:price*0. 90. Refer to the database premier products with tables: orders, order_line, parts. Assume that table parts has attributes: partnumber, description, on_hand, min_on_hand and price.