0
What is a database system and write atleast five features of good database system?
Wiki User
∙ 14y ago
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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How is a database different from a database management system?
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.
What is a transactional database?
A Transactional Database is a DBMS where write operations on the database are able to be rolled back if they are not completed properly.
Describe the database recovery process and the use of deferred-write and write-through techniques?
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.
How many paragraphs should you write in an FRQ?
you should atleast write 4 or 5 paragraphs
Did bowwow write outta your system?
Yes, Bow Wow sings and wrote Outta My System. The song features T-Pain and Jonta Austin.
Connect c language to internet database?
Yes, you can write a program in C language which connects to a database.
What percent of people can read and write in Switzerland?
Atleast 57.3% can read
How long did it take for EB White to write a book?
It had taken him atleast 5 years to write one book.
Would google translate write the Japanese translation backwards?
no, atleast not yet.
How do you design a database?
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.
Is it possible to perform a calculation within a database?
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.
What is the explanation for the salient features of windows?
write a detail note on microsoft window write its salient features
