Demerits related with conventional file processing systems
What are some of the demerits related with conventional file processing systems?
Expert
There are five demerits. Program-data dependence happens if file descriptions require to be changed in all programs when a file description changes. The duplication of data refers to the storing of data more than one time. Limited data sharing happens when the files are private so no one outside of one application can access the data. Lengthy development times exist since file processing systems acquires longer to develop. Finally, excessive program maintenance exists because the effort to maintain a program is bigger in this environment.
What is Data Manipulation Language?
State various types of the input links within the data stage?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre
States the term Global temporary.
Describe briefly Aggregate transformation?
Illustrates the basic elements in ER models?
Specify the designer tools used for creating the tranformations?
Illustrates the case statement present into stored procedure?
Illustrate the use and application of the DB Miner.
State the different advantages of the data warehousing?
18,76,764
1951713 Asked
3,689
Active Tutors
1423090
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!