PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following is the appropriate table detail sufficient to track the above attributes, correctly and

Philandrio Inc. is one of the largest drug manufacturing companies in the world. It has many offices worldwide.
Each office has a manpower of approximately 14,000.The managers themselves are employees in the
company. You are building a database for the company’s Human Resources Department (HRD). You want to
track the following attributes for each employee, and at the same time, eliminate duplicate entries and minimize
data storage wherever possible.
FirstName
MiddleName
LastName
EmployeeIdentityNumber
Address
Date_ of_ Hire
Department
Salary
ManagerIdentityNumber
Which of the following is the appropriate table detail sufficient to track the above attributes, correctly and
efficiently?

what will you do to accomplish the task?

You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order, such
that a row in the Order table does not exist without a corresponding row in the Product table. The structure of
the Product and Order tables with their respective columns is given below:
Product
ProductID
ProductNumber
Date_of_manufacturing
SupplierID
ProductPrice
ProductQty
Order
OrderID
OrderDate
OrderQuantity
OrderPrice
Based on this information, while maintaining the integrity of this rule, what will you do to accomplish the task?