Explain the database planning project, Database Management System

Assignment Help:

Explain the database Planning Project?


Related Discussions:- Explain the database planning project

Column constraints-on delete cascade, CREATE TABLE prodtrans ( pno ...

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

Physical dbms architecture, PHYSICAL DBMS ARCHITECTURE  The physical ...

PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

Which are two ways that entities participate relationship, Which are the tw...

Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship

One-to-many relationship, For each 1: n relationship type R involving two e...

For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en

Primary index, Primary index A primary index is a file that has a sorte...

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Differentiate between pl/sql functions and procedures, Oracle & Distributed...

Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.

Explain two phase locking protocol, Explain Two phase locking protocol ...

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

Referential integrity constraint - relational constraints, It defines that ...

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Two types of blocks in the fixed -length representation, What are the two t...

What are the two types of blocks in the fixed -length representation? Define them. Anchor block: Have the first record of a chain. Overflow block: Have the records other tha

Generalization and specialization, design a generalization specialization h...

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

12/5/2013 4:43:20 AM

The Database Planning Project- Strategic Database Planning is initiated by senior management.


They allocate resources and identify personnel to participate in project. With their commission from management, team members have resources needed to perform a successful project. The project team must be extensive experience in information systems and other functional areas of company. A group of four full-time members, two from information organizations and two familiar with mainly other areas of company. All team members have be skilled and respected employees, because their work would have a main impact on the organization for many years. If they are not skilled in a methodology for carrying out the study, an outside consultant must be employed as advisor to train the team in suitable methodology. The project team leader must be a consultant but permanent employee and possibly head of database administration.
All through the project, team interacts with senior managers from all primary user areas. The senior end users identify principal processes, activities and units used in manual or automated information processing. The project team produces these data into a corporate information model integrated as part of comprehensive database plan. A report covering at least next five have to be delivered to senior management. This report will include analyses of following:


1.(). Information requirements of functional areas.
2.(). Information wants of different management levels.
3.(). Information requirements of geographical locations.
4.(). A model of in sequence needs.
5.(). Anticipated data volumes by geographical location projects for the time under study.
6.(). A preliminary estimate of expenses associated with system upgrades.
7.(). Recommendations for detailed development of new or improved databases with schedules.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd