1. Given the generic relation: GENERIC (PKey1, PKey2, Attribute1, Attribute2, Attribute3), and
the functional dependencies: (PKey1, PKey2)  Attribute1 and PKey2  (Attribute2,
Attribute3), which of the following is true?

a.) GENERIC is not fully normalized.
b.) PKey1 is a determinant.
c.) PKey2 is a candidate key.
d.) GENERIC is in DK/NF.
e.) All of the above.
-----------------------------------
As far as Microsoft Access is concerned, there are no:

a.) 1:1 relationships.
b.) 1:N relationships.
c.) N:1 relationships.
d.) N:M relationships.
e.) recursive relationships.
----------------------------------

What relationship pattern is illustrated in the following schema:

. PRODUCT (ProductID, Description)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)

ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT

a.) Association relationship
b.) Intersection relationship
c.) Recursive relationship
d.) Strong entity relationship
e.) Supertype/subtype relationship


---------------------------------
What relationship pattern is illustrated in the following schema:

EMPLOYEE (EmployeeID, OfficePhone, Manager)

Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

a.) Association relationship
b.) Intersection relationship
c.) Recursive relationship
d.) Strong entity relationship
e.) Supertype/subtype relationship
-------------------------------

. Which normal form is defined as any table meeting the definition of a relation?
a.) DK/NF
b.) Boyce-Codd Normal Form
c.) 4NF
d.) 1NF
e.) 3NF
-------------------------------
. Which of the following is the correct technique for representing a M:N relationship using the relational model?
a.) An intersection relation is created and the key of either entity is placed as a key in both the intersection relation and in the other relation.
b.) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
c.) An intersection relation is created and the keys of both parent entities are placed as a composite key in the intersection relation.
d.) The key from either relation is placed as a foreign key in the other relation.
e.) None of the above.
------------------------------
The fundamental rule of normalization can be stated as every:
a.) table must meet the definition of a relation.
b.) determinant must be a candidate key.
c.) domain must be logical consequence of the constraints.
d.) key must be a candidate key.
e.) constraint must be a determinant.
-----------------------------
Which of the following would be a reason to denormalize a relation?
a.) Improve security
b.) Lack of design time
c.) End user preference
d.) Improve performance
e.) None of the above


مرفق صورة لسؤالين

ولكم جزيل الشكر يا أخوان

السلام عليكم
أشكر كل من قرأ الموضوع
ولكن للأسف لا يوجد أي رد
عموما توصلت لبعض الأجوبة و متبقي لدي هذه الأسئلة
أرجو الرد سريعا لمن يستطيع المساعدة

Which of the following would be a reason to denormalize a relation?
a.) Improve security
b.) Lack of design time
c.) End user preference
d.) Improve performance
e.) None of the above
-----------------------------------------------------------------------------------
As far as Microsoft Access is concerned, there are no:

a.) 1:1 relationships.
b.) 1:N relationships.
c.) N:1 relationships.
d.) N:M relationships.
e.) recursive relationships.
----------------------------------------------------------------------------------
What relationship pattern is illustrated in the following schema:

. PRODUCT (ProductID, Description)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)

ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT

a.) Association relationship
b.) Intersection relationship
c.) Recursive relationship
d.) Strong entity relationship
e.) Supertype/subtype relationship
----------------------------------------------------------------------------------------
What relationship pattern is illustrated in the following schema:

EMPLOYEE (EmployeeID, OfficePhone, Manager)

Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

a.) Association relationship
b.) Intersection relationship
c.) Recursive relationship
d.) Strong entity relationship
e.) Supertype/subtype relationship
----------------------------------------------------------------------------------------
Which of the following is the correct technique for representing a M:N relationship using the relational model?
a.) An intersection relation is created and the key of either entity is placed as a key in both the intersection relation and in the other relation.
b.) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
c.) An intersection relation is created and the keys of both parent entities are placed as a composite key in the intersection relation.
d.) The key from either relation is placed as a foreign key in the other relation.
e.) None of the above

خلص حليت الأسئلة كلها
و راح اقدم الامتحان قريبا

وعليكم السلام ورحمة الله

اعتذر عن التأخير ... فى الرد

كنت اتمنى ان تضع الاجابات حتى يستفيد الأعضاء

Which of the following would be a reason to denormalize a relation?

b.) Lack of design time

---------------------------
As far as Microsoft Access is concerned, there are no:
d.) N:M relationships.

---------------------------------------
What relationship pattern is illustrated in the following schema:

b.) Intersection relationship

-------------------------------------------

What relationship pattern is illustrated in the following schema:

c.) Recursive relationship

--------------------------------------

Which of the following is the correct technique for representing a M:N relationship using the relational model?

c.) An intersection relation is created and the keys of both parent entities are placed as a composite key in the intersection relation.
--------------------------------------------

حل سؤالى الرسومات المرفقه

الرسم الاول

N:1

الرسم الثانى

اختيار b