Questions from Database Systems

Q: What is the difference between a database and a table?

What is the difference between a database and a table?

Q: Create the table that would result from πstu_ode, dept

Create the table that would result from πstu_ode, dept_code (student ⋈ professor).

Q: How do you translate business rules into data model components?

How do you translate business rules into data model components?

Q: Create the basic ERD for the database shown in Figure Q3.

Create the basic ERD for the database shown in Figure Q3.8.

Q: Create the relational diagram for the database shown in Figure Q3.

Create the relational diagram for the database shown in Figure Q3.8. Data from problem 8:

Q: Write the relational algebra formula to apply a UNION relational operator to

Write the relational algebra formula to apply a UNION relational operator to the tables shown in Figure Q3.13.

Q: Create the table that results from applying a UNION relational operator to

Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.13.

Q: Create the table that results from applying an INTERSECT relational operator to

Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.13.

Q: Create the table that results from applying an INTERSECT relational operator to

Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.13.

Q: Using the tables in Figure Q3.13, create the table

Using the tables in Figure Q3.13, create the table that results from MACHINE DIFFERENCE BOOTH.