Two tables, namely, OrderItem and Item are depicted below in which all attributes mentioned
therein respectively, refer to column heading labels.

If the ItemName attribute is moved from the Item table to the OrderItem table, then will it violate
any normalization form? If yes, then which
of the following normalization forms will be violated?

You are the database administrator for a MySQL database. The database server is installed on a Unix
system. The time zone files for the system are located at /usr/share/zoneinfo. You need to ensure
that the system and MySQL time zones are based on the same information. Which of the following
statements will you use to accomplish the task?

You work as a Database Designer for Hitech Inc. You are designing a database named Project. The
company takes projects from outside and divides them into tasks (design, coding, etc.). Each task is
assigned to only one employee. You want to use a primary key constraint to uniquely define each
row in a table named Task. The tables are given below:

Which of the following attributes can be a primary key in the Task table?