dbms 3

.  A large e-commerce platform needs to support concurrent access by thousands of users, handle complex product catalogs, and provide real-time inventory updates.

Which system would be more suitable, a database system or a file system?

• Database System

• File System

• Both can handle it equally well

• It depends on the e-commerce platform's website design

You have two tables: "Employees" and "Departments." The "Employees" table has 500 records, and the "Departments" table has 10 records. You create a VIEW called "EmployeeDetails" to display the names and departments of all employees.

How many records will the "EmployeeDetails" VIEW have?

• 500

• 10

• 510

• It depends on the number of employees in each department.

3.  ______________ is a set of one or more attributes taken collectively to uniquely identify a record.

• Primay key

• Foreign key

• Super key

• Candidate key

A hospital database manages patient records. Patients can be categorized into inpatients and outpatients. Inpatients have additional attributes such as room number and admission date. Which database modeling concept represents this situation?

• Aggregation

• Specialization

• Generalization

• Indexing

Find the minimum number of tables required to represent the given ER diagram in relational model-

• 5

• 7

• 8

• 3

You are working on a database for an e-commerce website. You have tables for 'Customers' and 'Orders.' Each order is associated with a customer. What type of relationship is this, and how would you implement it?

In the e-commerce database scenario, what type of relationship exists between the 'Customers' and 'Orders' tables, and how would you implement it with foreign keys?

• One-to-One, using a foreign key in the 'Customers' table referencing 'Orders'

• One-to-Many, using a foreign key in the 'Orders' table referencing 'Customers'

• Many-to-Many, using a foreign key in both 'Customers' and 'Orders' tables

• No relationship needed in this scenario

Which attribute(s) can serve as a candidate key for the "Products" table?

• Serial Number

• Manufacturer Product Code

• Both Serial Number and Manufacturer Product Code

• Neither Serial Number nor Manufacturer Product Code

In a database for tracking employee information, you have a table that stores employee records. Each employee has an employee ID assigned by the HR department, and this ID is used to uniquely identify employees within the organization.

What type of key is the employee ID in this context?

• Primary Key

• Candidate key

• Super key

• Composite key

A hospital wants to design an ER model for its patient management system. Patients have unique IDs, names, and dates of birth. Doctors work at the hospital and have unique IDs and names. Patients can be assigned to doctors for treatment.

What entities and relationships should be included?

• Entity: Hospital; Relationship: Treats; Entity: Doctor

• Entity: Patient; Relationship: Assigned To; Entity: Doctor

• Entity: Patient; Relationship: Visits; Entity: Hospital

• Entity: Doctor; Relationship: Manages; Entity: Patient

In a music streaming service, you have two entities: "User" and "Playlist." A user can create multiple playlists, and each playlist is associated with one user.

What type of relationship should you represent in the ER diagram between User and Playlist?

• Many-to-Many relationship

• One-to-Many relationship

• Many-to-One relationship.

• One-to-One relationship.