Evaluate the internal factors that influence the design choices for a new databa

Question

Evaluate the internal factors that influence the design choices for a new database that will be used to collect and store a comprehensive inventory of existing IT equipment. Evaluate the external standards, practices, or regulatory requirements that will influence the design choices for a new database that will collect and store a comprehensive inventory of existing IT equipment. Describe the steps involved in designing a new database that will be used to collect and store a comprehensive inventory of existing IT equipment.

Explanation / Answer

Generally wile designing database,the factors should be know the purpose of the database and in whicg areas it stores. And also having decided which tables we need to divide information into different subjects, then only we eiil get clear purpose for the datsbase. After tat we have to determine the fields what information that we want to keep. The next factor is that applying the database relationship by viewing the tables and verifying the relationships. And then we need to analyze, refine, and modify.

Generally building any data warehouse consists of the following steps:

Extracting the transactional data:
The first thing we need to do while building a DW is that pulling data from various data sources to storage area.Ofcourse this is the most difficult step to accomplish due to the lot of reasons. For this microsoft has come up with an excellent too. This tool allows you to import and export data from any ODBC-compliant database. And also it is available at no extra cost when we purchase Microsoft SQL Server.

Transforming the transactional data:
Most companies have their data in various database management systems like MS Access, MS SQL Server, Oracle and also also have much of their data in flat files, spreadsheets.While building a data warehouse, we need to collect data from all of these sources need to move to target database And we need to figure out a way to relate tables and columns of one system to the tables.

Loading the transformed data into a dimensional database:
The dimensional model of database consists of the fact and dimension tables. And the tables consist of foreign keys and as well as measures.Dimensions are nothing but are what your business users expect in the reports. For example, the date dimension tells 2000 parts were produced between 1st and 10th.

Building a front-end reporting tool:

After completion of building dimentional tabel, we need to search for reporting tools need to use. If we have drill-down capabilities, Pivot Table Service of Microsoft Excel 2000 will do the job. But if the reporting needs more than what Excel can do, we need reporting tool.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.