Important Slides of DBMS Class

Case Study For Database Management

• http://pe.sdt.gatech.edu/sites/default/files/GTPEgtonline_description.pdf

Information Flow Diagram

Data Formats - Beg, Steal, Borrow

• The Data formats for the Input and Output Diagram.

• These Data formats are applicable to the attribute types of the entities.

Constraints

• Program the constraints into the application program.

• Each of the Task identified in the IFD diagram, we have to decide

• Need of Mother Task.

Example Task Decomposition

Example of View Profile Abstract Code

• No formal syntax for Abstract Code

• Penultimate Step before we write it in SQL

Task Decomposition of Edit Profile

Example of Abstract Code

• Let’s take a look at test decomposition for friend requests. The idea gain is that we have the forms that are the interface to the application.

• And our job is to now talk about the decomposition of the tasks that are necessary in order to tie these forms through the task into the database.

• If we did a closer analysis using the rule of thumb for task decomposition for this task we would arrive at the following result.

• The request friend test would be separate from the others. This task would update the database with a request and would support this form.

• The view, cancel, accept, and reject request task is the one that supports this form, and supports actions taken to the requests that are pending. It would end up being decomposed in two subtasks, view the request and then support the accept, reject, and cancel options. This subtask would update the friendship relationship type. This task would support the reading of user and regular user and friendship information.

Review of EER

Task Decomposition

View Profile Task Decomposition

Edit Profile - 1

Edit Profile - 2

Edit Profile - 3

SQL Request Friendship

SQL View Pending Requests

SQL Accept, Reject, Cancel Friend Requests