Scope of traffic data management, Database Management System

Assignment Help:

A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics:

  • Traffic data management systems project's objectives are by and large defined in general statements. It is significant that the requirements for the traffic data developments are not be very explicit. If they are very definite, they may affect the way the traffic data project is designed, to the point of "not including" factors that seems unrelated but may be key to the analysis being carried out.
  • One of the major reasons for describing the scope of the project is to avoid invariable change throughout the life cycle as new requisites occur.
  • The key purpose of the TDMS project is for data analysis but not to muddle up operational objectives with the traffic data project's informational objectives.

The project will be developed in Oracle in all aspects. The Oracle 10g Database's Enterprise Edition will be used for the server. For development of ETL, and metadata repository Oracle 10g Warehouse Builder will be used. Report builder or discoverer will be used to create the reports that will be available using any web browser. The system will also be responsible for the data to clean on a regular basis. The operational data will be held in transaction-based systems with some function like equipment basic data, management and staff current data. Audit trial will also be managed.

When tables are created there will be some advanced indexing techniques will be used which will improve the data retrieval and overall performance of the system. Some views are to be created for the purpose of the enhancing the performance of the data.


Related Discussions:- Scope of traffic data management

Write a query to find name from the relational algebra, Consider the relati...

Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find

Search the salary of employees who are not ‘analyst’ , Example- Search the ...

Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP

Example on relational database schema, Question: The following relation...

Question: The following relational database schema corresponds to a part of a database used by the Registry Department of a university. DEPARTMENT (d#, d-name, head-of-dept)

List some security violations, List some security violations (or) name any ...

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Distributed database management system, Question (a) Differentiate betw...

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

ER diegrams, How to draw an ER diagram to a finance companz

How to draw an ER diagram to a finance companz

What is an entity relationship model, What is an entity relationship model?...

What is an entity relationship model?  The  entity  relationship  model  is  a  collection  of  basic  objects  known as entities  and  relationship  between  those objects. An

Equi join-table handling, Equi Join: A join in which the joining condition...

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Create data base table apply key and functions, CREATE YOUR DATABASE TABLES...

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables

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