Necessity of database redesign
Describe any two reasons which show the necessity of database redesign?
Expert
Database redesign is vital for two reasons which are as follows:
(i) Redesign is essential both to fix mistakes made throughout the initial database design.
(ii) Redesign is essential to adapt the database to changes in system requirements. These changes are common since information systems and organizations don’t just influence each other they create each other. Therefore, new information systems cause alters in systems requirements.
Write a short note on the difference between the disjoint and overlap rule.
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Explain difference types of the stages?
What are some of the demerits related with conventional file processing systems?
Why recursive relationships are not good? How do you solve them?
What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)?
How many modes are there in Business objects and Designer?
Describe briefly the difference between a Java applet and a Java servlet?
Explain the way through which we can publish BO report?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
18,76,764
1927660 Asked
3,689
Active Tutors
1453458
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!