Planning+and+Designing+Database+Systems

media type="custom" key="4399703"Planning and designing a database system requires a combination of knowledge, skills, and creativity. This job is ususally handled by a systems analyst. A systems analyst may also become responsible for administering the database after it is built. System analysts or database designers follow three steps to plan a database The user requests and enters data through the front-end interface program. The database management system manages the retrieval and update of the database itself.
 * 1) **Create** an organizational structure for the data
 * 2) **Design** an interface that makes the database user-friendly
 * 3) **Set up** reporting capabilities to allow for inquiry and response

[|Database Objects] **: Tools in the Database Managment Systems (DBMS) -** A database object is an element within an object-oriented database, such as a form, a report, or a data filter. Database designers use database objects to build the system interface and the reporting features.
 * [|form] - template that allows users to enter data into the database - default answers are included to ensure that the database has all the data required for its fields
 * [|reports] - formatted body of output from a database (examples would be: phone bills, report cards, and grade transcripts)
 * **data filter** - filtering material in a database to restrict a database search - the more limited and focused the result, the greater the likekihood that the report offers the desired content

