Managing The People Involved In The Database Project

Project
     A planned undertaking of related activities to reach an objective that has a beginning and an end.

A system of database Development Team can include one or more of the following.
1: Business Analyst:
    These individuals work with both management and user to analyze the business situation and develop detailed system and program specification for project.

2: System Analyst:

    These individuals may perform business Analyst activities.
3: Database Analyst & Data Modelers:
    These individuals concentrate on Determining database components of the information systems.
4: Users
    User provide assessment of these information needs and monitor that the develop system meets their needs.
5: Programmers:
    These individuals design and write computer programs.
6: Database Architects:
    These individuals establish standards for data in business units.
7: Data Administrators:
    These individuals have responsibility for existing and future databases.
8: Project Managers:
    Project managers oversee, assign project including team compositions and analysis, design, implementation and support of projects.
9: Other Technical Experts:
    Other individuals are needed in areas such as networking, OS, Testing, data ware Housing and documentation.

Three Schema Architecture in Database Development

1: Enterprise Data Modal:

During the information system planning phase.

2: External Schema / User View:

During the analysis and logical designing phase.

3: Conceptual Schema:

          During the analysis phase.

4: Logical Schema:

          During logical design phase.

5: Physical Schema:

          During the physical design phase.

It is important to keep in mind that all these schemas are just different ways of visualizing structure of the same database by different stake holders.

The three schema architecture as defined by ANSI are as follow.

1: External Schema:

This is a view of managers and other employer, who are the database users. The External Schema can be represented as a combination of the enterprise Data Model and a collection of detailed user-views.

2: Conceptual Schema:

          This schema combines the different external views into a single and comprehensive definition of the enterprises data. The conceptual schema represents the view of the data architecture or data administrator.

3: Internal Schema:

          Internal Schema consists of two separate schemas.

                              i.            Logical Schema

                             ii.            Physical Schema

I: Logical Schema:

          The logical schema is the representation of data for a type of data-management technology.

II: Physical Schema:

          Describes the how data are to be represented and stored in secondary storage using a particular DBMS.

Types of Reports

There are two major types of reports according to their format and style.

1. The Short Report or Informal Report
2. The Long Report or Formal Report

The Short Report:
        Short report may comprises a single page like a letter addressed to a particular person at whose instruction the report is made.Short report also include signature, date, subject and heading. In style the informal report is personal and subjective. The subject matter of this type of report is presented in the following steps.

1: Terms of Reference:
        It is the beginning of the report in which the scope of the report is mentioned.
2: Procedure:
        In procedure the method of investigation is indicated, sources, consultants and inquiries made are also mentioned.
3: Findings:
        During the process the writer observed and collects many facts about the problem.These findings are mentioned in this part of report.
4: Conclusion:
        The result which is drawn by the writer from the facts is given in the conclusion.
5: Recommendation:
        If the writer is allowed to give suggestions he include their recommendation in this part of report.

Class Update

Friends aj OOP aor P.S k mid k papers check ho gaye hain.

Class Update

Friends Database k Professor, Sir Zubair Nabi ne aj Mid k papers check krwa diey hain...

BUSINESS REPORTS

Definition: 

"A business report is an orderly representation of Facts about specific business activity or program."  

        Though it consist of mainly facts, but it also consist of writer's personal study, observation, interpretation, conclusion and recommendations.The British Association for commercial and industrial education define a business report as:

"A document in which a given problem is examined for propose of convening information and findings, putting forward ideas and sometime making recommendations."

So we can say that a business report comprises three important points:
1: Study of the problem.
2: Findings about problem.
3: Recommendation to solve the problem.

Uses are importance of business reports.It is an essential part of business communication. Reports are very necessary for the promotion of any business.These are the important advantages of business reports.
1: They save the time and money of executives.
2: They provide suitable information to understand the problem.
3: Reports form the basis for the decision and action.
4: They serve as evidence of work that has been done.
5: They are permanent record of the business.
6: They are consulted and referred any time.
7: Now reports are permanent part of any modern business or organization.

So we can say no business can be run smoothly in the absence of these reports.Reports are very necessary to enhance and promote the business.