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);

relationship with the owner entity, A database for the Service and Mainten...

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

Explain the three data anomalies, What are the three data anomalies that ar...

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

Spanned and unspanned organisation, Spanned and unspanned organisation? ...

Spanned and unspanned organisation? Spanned and unspanned organization: If records are not permited to cross block boundaries then the organisation is called unspanned record

Er diagram, Draw an ER diagram for company''s database schema

Draw an ER diagram for company''s database schema

Define partial key and primary key, Define Partial Key and Primary Key ...

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus...

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

What is the use of group by clause, What is the use of group by clause? ...

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

There are two major types of fragmentation, There are two major types of fr...

There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes

What is data independence, What is data independence? Data Independenc...

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

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