Sol 3. (a) A Star Schema is required to use primary and foreign keys in order to maintain the data's referential integrity due to the built-in referential integrity. Primary keys in the dimension table are translated to foreign keys in the fact table to connect each record between the two tables. (b) The Delete operation can only sever referential integrity. This occurs if the tuple that is being deleted is referenced by a foreign key from another tuple in the database. To remove a foreign key constraint from INSERT and UPDATE transactions in SQL Server, use Transact-SQL or SQL Server Management