You are developing a database for a social media platform. You have tables for 'Users' and 'Posts.' Each post is created by a user, and a user can have multiple posts. How would you implement this relationship using foreign keys?

Consider a database table "Students" with the following attributes:

Student_ID (Primary Key), Student_Name, Course_ID (Foreign Key)

If there are 100 records in the "Students" table, and each student is enrolled in one of the five available courses, how many unique values can the "Course_ID" column have?

A car rental company manages its fleet of vehicles in a database. The vehicles can be categorized as cars, trucks, and vans. Each category has specific attributes, such as maximum cargo capacity for trucks. Which DBMS concept is most appropriate for modeling this scenario?

Identify the minimum number of tables required for the following ER diagram in relational model:

You are designing a database for an e-commerce platform. Each customer has a unique email address, and you want to ensure that this email address is used as a unique identifier for customer accounts.

Which key should you use?

A University wants to model its student information system. Students have a unique ID, name, date of birth, and email address. Students are also enrolled in courses, and each course has a name and a unique course code.

What entities and relationships are involved?

A small local library wants to keep track of its book inventory. They have a limited budget and don't require complex querying capabilities. Which system would be more cost-effective, a database system or a file system?

The ability to query data, as well as insert, delete, and update tuples, is offered by ____________.

You are designing an ER diagram for a university database. There are two main entities: "Student" and "Course." Students can enroll in multiple courses, and each course can have multiple students.

What type of relationship exists between Student and Course?