Need database design process

[Mrigankasekhar]

Hi all,

I am a student from south California University. I build a project on the university database. I need some help from you. I need database design process and some documentation on it. Please help. Thanks in advance.

[Praetor]

You need database system design process as follows:

# Requirements Analysis Requirements Analysis.
# Conceptual database design, Conceptual Schema Design.
# Logical Database Design Logical schema design.
# Physical Database Design Physical Schema Design.
# Realization of Implementation.
# System Testing System Testing.
# Maintenance Delivery & Maintenance.

[Katty]

You need to do following steps for database design process.
# Analysis of user activity, resulting in business process diagrams: Understanding the user's current operational activities and functions, clarifying its processes. The user is divided into several sub-business processes, so that each processing a clear interface clear, draw business process diagrams
# Determine the system-wide, resulting in system-wide plans: In and users have been fully discussed, based on a computer can determine the scope of data processing to determine what kind of work be completed by hand, what kind of work by a computer system to complete, that is, determine the man-machine interface.

[kelfro]

In database design process, Analysis of user activities involved in the data, resulting in data flow diagram: In-depth analysis of the user's business processes, data flow diagram (Data Flow Diagram, DFD) expressed the form of data flows and data for processing. DFD has four basic components: data stream, processing or treatment, documents, external entities. DFD data flow can be vividly expressed the relationship with the various business activities, it is the needs analysis tools and analytical results describe the means. All the best.

[MindSpace]

It is very essential in database design process, To analysis of system data to generate a data dictionary: just a DFD does not constitute a demand specification, DFD only show that the system which of these components and the relationship between the various parts, and did not specify the meaning of the various elements. Data Dictionary provides a database of time described in the centralized management, and its function is to store and retrieve various data descriptions, data dictionary is the data collection and data analysis of the major achievements in the database design plays an important role. The basic requirements for the preparation of the data dictionary. Check and reply.

[opaper]

You need to Functional Analysis in database design process that is a database design of application systems closely integrated process, leaving a certain degree of functionality, the database loses its value. An important feature of the database design is the structure (data) and behavior (functions) combination. Users want the system to provide the function must have a clear description. Functional analysis can use the software structure chart or block diagram to represent the decomposition of the relationship between the level of the system, module, called the relationship. Best of luck.