If a student database is not maintained, problems such as inaccurate or outdated information may be stored, leading to difficulties in tracking student progress, communication errors, and issues with administrative tasks like enrollment or grading. This can result in confusion, inefficiency, and frustration for both students and faculty.
Typically, a database versus a data warehouse, is "OLTP" (online transaction processing). That means that live inserts/updates/deletes happen to the database all the time. A data warehouse is used for statistics and trending. Nighly data feeds from stores are populated into the tables. During the day, no inserts/updates/deletes occur on the database--it is used for data gathering (queries) only.
Data inconsistency is one of the problem that occurs in the database..Data inconsistency means various copies of the data no longer agree..(inconsistency- unchanging)example:-If a student want to make change in his records, the changes must be made in each and every pages that needs changes..ex:- if a student changes his address, the new address must be changed in all applications in the institution that require address. The changes doesn't occur automatically in all pages when it is made in one page.
Data diddling refers to the unauthorized manipulation of data by changing, deleting, or inserting information for personal gain or to cause harm. This can occur within a computer system or database, often resulting in fraudulent activities or compromised data integrity.
Large databases have a dramatic impact on privacy. If a hacker or another person with equally malicious intent tapped into one of these databases and used the information improperly, problems such as identity theft and financial abuse could occur.
Procedures in an RDBMS are programs that are written to accomplish a set of functions that cannot be done using a single query. A procedure contains a sequence of SQL Queries that can be executed one after the other by invoking the procedure. There are two kinds of procedures Functions & Stored Procedures.
What problem can occur if a student database is not maintained
The student may be embarraced.
Database integrity refers to the safety of data. For example a transaction is made from an account of rs 500 and in between of transaction there is an abrupt , then integrity of data will be maintained and transaction will not occur.
what problems can occur if a highway have sharp bends
what problems can occur if a highway have sharp bends
what problems can occur if a highway have sharp bends
It is an attribute that does not occur in some candidate key.
The purpose of normalization is to reduce the chances for anomalies to occur in a database. The Normalization also forces you to use a database in a Object orientated manner. (This is good of course.)
you would gain tons of weight and develope heart problems and diabetes theres a hefty list of problems that can occur.
How do you deal with the problems which may occur during your work and how to report these
What problems can occur from engine oil overfill
Referentail dependencies occur when an object is referenced in the definition of another object