0
What else can I help you with?
It is possible to have more than one table in a relational database?
You have to have more than one table in a relational database. In a relational database tables are designed to be related to other tables, so there has to be a minimum of two tables. Quite often there are a lot more than two.
Why is a computer database better than a manual system?
The main advantage of a computer database is that it is space saving. Unlimited updates may be done without running out of space. What would have been a time consuming search through records is minimized to within seconds on a computerized database.
When would you want to use a relational database?
The word 'relational' in an RDBMS stands for relationships between tables (parent and child). So whenever you have information that can benefit from such a feature you would use relational database. For example, a customer places many orders and each order has items. This type of real world scenario is better represented in a database than in a spreadsheet for example.
Why do you learn database model?
It helps you to design a database. It is a theoretical idea of what it will be like. There are different models than can be used, such as relational or network or hierarchical. Some are better suited to some kinds of databases. Using the model helps people to design and build better databases.
What are disadvantage of database?
It's slacking off all the time rather than being an actual database.Ans2:You sure you don't mean "Relational database"?
What are disadvantages of recreational database?
It's slacking off all the time rather than being an actual database.Ans2:You sure you don't mean "Relational database"?
When using a query in a hierarchical database the results often are displayed more quickly than a relational database?
Because the structure of a hierarchical database is set, indexes can be created and utilized for easily that a relational database, where useful indexing is not often an option. Since an index allows direct access to specific data, data retrieval can be much quicker. Additionally, only a few segments are retrieved at a time with hierarchical data, instead of whole resultsets from relational queries.
Why relational database approach is better than earlier method?
Relational model helps in logical relation between two dimensional tables . It maintains data integrity and eliminates data redundancy. Earlier methods involved redundant set of data for maintaining relations between set of data.
What are the typical benefits of relational databases?
With a relational database, you can quickly compare information because of the arrangement of data in columns.A typical relational database has anywhere from 10 to more than 1,000 tables. Each table contains a column or columns that other tables can key on to gather information from that table.By storing this information in another table, the database can create a single small table with the locations that can then be used for a variety of purposes by other tables in the database. A typical large database, like the one a big Web site, such as the police would have, will contain hundreds or thousands of tables like this all used together to quickly find the exact information needed at any given time
Problems of manual database?
A manual database takes longer to update than an automatic database. This is because all of the information must be added manually each time.
Differentiate manual database to a computerized database?
A manual database is a paper based database. A computerized database is one which is held on a computer in an organised manner. A computerized database is more advantageous than manual database in terms of speed, flexibility, and ease.A manual database would normally be data held on paper. So this could be things like a phone book or address book, or files held in a filing cabinet. A computerised database is held on a computer in an organised and structured form. Usually this is done using a database application such as Oracle or Access etc. It is easy to manipulate and extract data, so far more efficient than a manual database.
What is the advantage of relational database model?
The advantages are as follows: The relational database model is by far the most widely used. It is easier to control, more flexible, and more intuitive than other approaches because it organizes data in tables. The relational model can also be used with personal computers and mainframe systems. It allows tables to be linked. This linkage is especially useful when information is needed from multiple tables.
