0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What kind of problems are associated with redundancy in databases?
problems associated with redundancy in data base,
Redundancy occurs in same data multiple time tends to several problems some times redundancy controlling is necessary to improve the performance of the query.
How is data warehouse different from a database?
A database is a storage of data in its most generic form. Data stored in a data might be used for data warehouse, CRM or many other types of data management uses. A simple database is used in many common computer applications from virus checkers, where data is stored about every known computer virus, to movie editing software where video clips are stored in a database as they are edited.
A data warehouse describes a specific type of database application that is usually used for analytics. Data warehouse also implies some set of processes for the data within, as well as some business value from the analytics. A data warehouse could be a a collection of databases related to the analytical mission.
When does a DBA use backwards recovery?
-Undo problem transactions
-Apply before images from log to undo their updates
A Document Type Definition (DTD) is a set of markup declarations that define a document type for an SGML-family markup language (SGML, XML, HTML).
A DTD uses a terse formal syntax that declares precisely which elements and references may appear where in the document of the particular type, and what the elements' contents and attributes are. A DTD can also declare entities which may be used in the instance document.
How many relations may exist between two tables in a MS Access database?
only one relationship can exists between two tables in the MS ACCESS software
What are the benefits of avoiding redundancy in a database in access?
Avoiding redundancy in a database in Access enhances data integrity by minimizing the risk of inconsistencies and errors, as updates need to be made in fewer places. It improves storage efficiency, reducing the amount of disk space required for data storage. Additionally, streamlined data management facilitates easier maintenance and faster query performance, leading to improved overall system performance and user experience.
Is Redundancy in database is a desirable characteristic?
It could be, and could not be at the same time. I'm going to use SQL for an example. Say you have a website, and a user signs up. You would have a users table, first off to store the users information. Then, you would have another table with the actual content that that user has stored. The repeating field would be the USERID.
But, if you have the same data stored twice in two different tables, that's a bad thing.
Is it true that database management systems create and manage databases?
yes it mange database and also create it.
Is there any relationship between Testors Models and Pocher Models?
testor models are testors of models and pocher models are reciprocals of tester models
Where does the data appears in the patient management tab come from?
ytyduasdgjsdjdgsdghsfdtsfduuwyegdueud86376376ejhdgieyrd77e6r7er5t3737evw gyfdgydgfyjdf.jshduiyestrr
.
If you want a free one , you can go to Microsoft.com and search for MSSQL Server express and download it.You will need the one with the management console or use the mssql server books online to create and manage your database.It is relatively easy to administer databases with.
There are several other free database servers out there , but I have not worked with any of them yet.
Oracle has a free version of their database management system , but I don`t know how to use it.I couldn`t tell you whether it is as simple as Microsoft`s version or not , but you could check it out.
What is an inner join in access?
for me to have easy access in helping me make my computer assinments in school..
'''PERSON''' '''The human beings are the subject of rights and duties in law if understood in strict sence of the word, but, sometimes a situation may arise when persons other than human beings such as corporations are also capable of enjoying rithts and duties they are also regarded as person in Jurisprudence and Law. There may be human who are not persons like slaves who are, notwithstanding, being human beings are not in law capable of having rights due to incapacity of their fact of being slave as their'''
What is importance of Database Management?
database is collection of table...i.e it is collection of record or data.it is more useful than file management system....
G1
Why is it important to have database?
the database is used to maintain the data properly and it is easy to recover.
