Practice exercises. Database design. Relational model. (Chapter 2, 3) презентация
Содержание
- 2. Exercise 2.4 Problem A company database needs to store information about
- 3. Exercise 2.4 Problem Employees work in departments; each department is managed
- 4. Exercise 2.4 Solution First, we shall design the entities and relationships.
- 5. Exercise 2.4 Solution
- 6. Exercise 2.4 Solution Now, we will design the constraints. “…each department
- 7. Exercise 2.4 Solution
- 8. Exercise 2.8 Problem Although you always wanted to be an artist,
- 9. Exercise 2.8 Problem Galleries keep information about artists, their names (which
- 10. Exercise 2.8 Problem Each group is identified by a name (like
- 11. Exercise 2.8 Solution Like before, we begin with the entities and
- 12. Exercise 2.8 Solution “Pieces of artwork are also classified into groups
- 13. Exercise 2.8 Solution
- 14. Exercise 2.8 Solution Now we look at constraints. Although not
- 15. Exercise 2.8 Solution
- 16. Exercise 2.8 Solution Suppose we had several piece of artwork with
- 17. Exercise 2.8 Solution
- 18. Exercise 3.14 Problem Consider the scenario from Exercise 2.4, where you
- 19. Exercise 3.14 ER Diagram from Exercise 2.4
- 20. Exercise 3.14 Solution First we begin with the entities “Employees” and
- 21. Exercise 3.14 Solution
- 22. Exercise 3.14 Solution Next, we translate the relationships, Manages and Dependents.
- 23. Exercise 3.14 Solution
- 24. Exercise 3.14 Solution Why did we make dno the primary key
- 25. Exercise 3.14 Solution Finally, we translate the weak entity “Child” and
- 26. Exercise 3.14 Solution
- 27. Exercise 3.18 Problem Write SQL statements to create the corresponding relations
- 28. Exercise 3.18 ER Diagram from Exercise 2.8
- 29. Exercise 3.18 Solution The entities are translated similarly to Exercise 3.4.
- 30. Exercise 3.18 Solution
- 31. Exercise 3.18 Solution
- 32. Exercise 3.18 Solution
- 33. Exercise 3.18 Solution
- 34. Exercise 3.8 Problem Answer each of the following questions briefly. The
- 35. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 36. Exercise 3.8 Solution for (1) An example of a foreign constraint
- 37. Exercise 3.8 Solution for (1) Furthermore, when a user attempts to
- 38. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 39. Exercise 3.8 Solution for (2) Emp(eid: integer, ename: string, age: integer,
- 40. Exercise 3.8 Solution for (2) Dept(did: integer, dname: string, budget: real,
- 41. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 42. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 43. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 44. Exercise 3.8 Problem Emp(eid: integer, ename: string, age: integer, salary: real)
- 45. Exercise 3.8 Solution for (6)
- 46. Exercise 3.8 Solution for (6) What other actions can the system
- 48. Скачать презентацию
Слайды и текст этой презентации
Скачать презентацию на тему Practice exercises. Database design. Relational model. (Chapter 2, 3) можно ниже: