Database is a collection of interrelated data. Database management system is collection of data and a set of programs to access and modify that data. There is a technique called normalization used to make good database design. Normalization helps to reduce redundancy from the data. There are different normal forms, each normal form is used to make database in standard form that is free of problems. If database is not designed well, it exhibits following problems called Update Anomaly.
there different types of anomaly exists and they are as follows:
Insertion anomaly: It is difficult to insert required data as not availability of other data.
Deletion anomaly: We can not delete unnecessary data cause as we delete those data necessary data will also be deleted.
Update Anomaly: We can not update attribute in a table because there may different values for the same attribute in same table.
There are several advantages of DBMS, and they are as follows:
- data can be retrieved easily and quickly,
- easy to impose integrity constraints,
- no redundancy,
- easily to maintain ACID property of transaction
- easily to update data.
A database is simply the data that has been stored in tables. A database management system includes all the elements that are required to work with the database. This would include things like the language to write queries, facilities for creating reports, controls over security and access of data and other elements.
A Transactional Database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly.
deferred-write: The transaction do not immediate update database, instead, only update log file. Then when transaction reach commit point, it will update the physical database. write-through: The database is update right away during the transaction execution.
you should atleast write 4 or 5 paragraphs
Yes, Bow Wow sings and wrote Outta My System. The song features T-Pain and Jonta Austin.
Yes, you can write a program in C language which connects to a database.
Atleast 57.3% can read
It had taken him atleast 5 years to write one book.
no, atleast not yet.
hmm, I start to think what am will doing with database, usually I write firts all my idea on a paper and when it ready to build, I use my database application.
Yes you can. You can create queries that do calculations. You can write code for programs to do calculations in a database. Doing calculations is a significant element of what you do with a database, so yes you can do them within a database.
write a detail note on microsoft window write its salient features