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?

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

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 a user 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 multiple
games. 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 fixed
fee 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 in a 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?

Which of the following is an ANSI approved language for communicating and managing data in a
relational database management system (RDBMS)?