Quiz 1- FEDM

In an ERD, what is the function of a "Derived Attribute"?

• Represents an attribute that can have multiple values

• Depicts an attribute composed of sub-attributes

• Illustrates an attribute that is calculated from other attributes

• Represents an attribute that uniquely identifies an entity

The number of entities to which another entity can be related through a relationship set is called?

• cardinality

• entity

• attributes

• schema

If two entities have many to many relationships, it  mostly results in how many tables?

• one

• two

• three

• four

A simple attribute is: 

• An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity

• An attribute that holds multiple values for a single component

• An attribute that cannot be further divided into sub-attributes

• An atribute composed of multiple components each with individual existance

. 

An ERs purpose is to support a user's perception of the data and conceal the technical aspects associated with database design. True or false? 

• True

• False

An e-commerce website is planning a database to store information about products, categories, and customer orders. Each order can contain multiple products, and each product can belong to multiple categories. What role would the "OrderDetails" table play in the ERD for the e-commerce website?

• Strong Entity

• Weak Entity

• Associative Entity

• Recursive Entity

An online music streaming service is planning a database to manage information about users, playlists, and songs. Each user can create multiple playlists, and each playlist can contain multiple songs. What type of entity would "Playlist" be classified as in the ERD for the music streaming service?

• Strong Entity

• Weak Entity

• Associative Entity

• Recursive Entity

A social networking platform is designing a database to manage user profiles, posts, and comments. The platform wants to implement a notification system to alert users about new comments on their posts. You need to design an ERD that includes an entity representing notifications. How would you implement a relationship between the "User" entity and the "Notification" entity to achieve efficient notification tracking?

• Many-to-Many relationship with an associative entity

• One-to-Many relationship with a foreign key

• Recursive relationship within the "User" entity

• Introduction of a ternary relationship involving "User," "Post," and "Notification"

Which of the following statement is correct regarding a relation in second normal form?

1. It is in first normal form.

2. Every non-key attribute is fully and functionally independent on the primary key

• Neither 1 nor 2

• Only 2

• Both 1 and 2

• Only 1

In the __________ normal form, a composite attribute is converted to individual attributes.

• First

• Second

• Third

• Fourth