Explain the database planning project, Database Management System

Assignment Help:

Explain the database Planning Project?


Related Discussions:- Explain the database planning project

Express the queries in relational algebra, Question: This question refe...

Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Develop a flowchart using the decision structure, 1.  Develop a flowchart u...

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

Difference between clustered and a non-clustered index, What are the differ...

What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

Query to delete constraint from alter table, A constraint named less_than_2...

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Max. no. of structures in a table or structure, What is the max. no. Of str...

What is the max. no. Of structures that can be included in a table or structure. Nine.

What are costs to be considere when transaction is roll back, What are the ...

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Relational algebra and calculus, Q.  What is relational algebra and calcul...

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

aggregate functions-data manipulation language, Aggregate functions ...

Aggregate functions Some of these functions are min, count, max, and avg. These functions help in getting consolidated information from a set of tuples. Example:

What is boyce-code normal form, Boyce-Code Normal Form (BCNF) A relatio...

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

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