- How does CAP theorem affect database general characteristics? Give an example of a database that complies with ACID properties and compare it with another database that utilizes BASE.
- Describe ACID attributes briefly.
- Think of a scenario where one can utilize different database categories to fulfill different business requirements.
- What is the difference between tuple and set?
- 3VL is used in the relational model; give examples of NULL value interpretation.
- Why should the tuples in the relation be unique? Which constraint ensures tuple uniqueness?
- Given two relations where both relations have 10 tuples and five attributes, assuming we have applied the Cartesian product on the two relations, what is the total number of attributes and tuples for the resultant relation?
- What is a domain constraint? List domain constraint types. Assuming a relation, client, has an attribute, phone_number, define the domain constraint for this attribute.
-
Imagine that you have been assigned to a team that will be developing the online car portal system. As the team leader for the data design team, you have to provide a work plan that identifies the phases of data design. For each data model perspective phase, provide the following:
- The scope of the data modeling phase
- The inputs of the phase
- The outputs of the phase