MIS questions. please help

We have the following tables with the associated columns: Order: Orderld, OrderDate Ordertineltem: Orderld, OrderSequence, ProductiD Product: Productld, Product Name Which column or columns in each table are foreign keys? (Please see Figure below) Order: none; OrderLineltem: OrderID and ProductID; Product: none Order: OrderID; OrderLineltem: OrderID and OrderLineNumber; Product: ProductID Order: none; OrderLineltem: OrderID and OrderLineNumber; Product: none Order: OrderID; OrderLineltem: OrderLineNumber; Product: ProductID Which of the following does not violate the referential integrity of a database? updating a foreign key with a value that doesn't match a primary key in the related table deleting a row in a foreign key table without deleting the related row in the related primary key table inserting a new row into a table with a foreign key that doesn't match a primary key in the related table updating a primary key in a primary key table without also updating the foreign keys for the related rows in all related tables While designing a database you identify duplicate data in a table. You decide that some of these attributes should be split out into their own table. What is the next step in your design process? Decide on the data type of the data elements Assign a primary key to the newly created table Create linking tables between the new table and old one Assign a foreign key to your original table Subdivide data elements to a useful form