MIS questions. thank you

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 Tables that are in a "denormalized" format typically result in all but one of the followine. Which one 2 pts is it? redundant data reduced efficiency in the questions that can be answered larger tables (i.e. more rows) more complicated SQL coding fever tables The interface between an application program and the DBMS is usually provided by the front-end client network back-end server programmer data access API