Two tables, namely, OrderItem and Item are depictedbelow 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. Youare 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?

Which of the following is the process of creating adesign for the database that will support the enterprise’s
operations and objectives for the required databasesystem?

You manage a database named Exams accessed via a website. The website is regularly accessed by users in
different countries. You are redesigning a table named History that records when users have purchased and
taken online exams. You need one of the columns in the History table to record what time of day that auser
has taken an exam. Additionally, you need this column to have time zone awareness. What data type should
you use?

Fill in the blank with the appropriate word.
The model for database management is a database model based on first-order predicate logic.

You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiplegames.
You are working on a relation shown in the image below:

Which of the following candidate keys would best serve as the primary key?

You are designing a database for a sports hostel. There are three types of buildings for which a fixedfee is
charged on per room basis. No player can take two accommodations. You design the following table:

Considering that the P_ID is the primary key, the table is in which normal form? Each correct answer
represents a complete solution. Choose all that apply.

You work as a Database Administrator for Dowtech Inc. A table named StudentInformation exists in a
database. The table has columns named student_names, student_marks, and student_courses. Some
students who have opted for various courses have got different marks in them. This implies that the table has
two many-to-many relationships. You have to ensure that these two relationships are not represented ina
single table and that the student_name column exists in both tables. Which of the following normal forms will
you use to represent these relationships in the tables?

Examine the following table:

What is the degree of this table?