0
A flat-table database is one that uses a single table to store all relevant data.
By contrast, a relational database uses several tables to store relevant data, and then establishes 'relations' between them using unique identifiers ... such as primary keys and foreign keys.
Flat-table databases are ok if the data is not too complex or repetitive.
Relational databases are good when the data is complex and repetative.
For example: Keeping track of a personal music CD collection - if one is lazy - can simply be done in a flat-table database table (or a spread sheet). It can also be done in a relational database by creating a few tables and relating them. One table can be artist (with a primary key), another table can be album (relates to a single artist primary key), and a third can be a record label table (which can relate to many artist primary keys).
This is a very high-level view of the differences. I .
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Data base state vs database schema?
The database schema is the description of the database. It defines how the database is set up and what data it is to contain and control. This description is given to the DBMS to manage the data. The database state is an image of how the database looks at any given time. The database schema is set unless you change how the database is structured. The database state will change whenever new data is entered into the database and the database is updated.
What are the advantage of distributed database over centralized database?
The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .
What is a database field name?
it is something in the database
What is a database that has no data and has no database tools in which you create the data and the tools as you need them is reffered to as a?
Blank Database
What are names of databases?
Database names are the identifying names that users provide when creating a database. These names must be unique within the location in which they are cataloged. The name differentiates the database from any other database in either the local database directory or the system database directory
What kind of application in MS Access?
It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.
Enter on the database or in the database?
We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.
What is a derived database?
We know what is database, it is a collection records. When a database is created from the existing database it is known as derived database.
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
What is the range of database application?
The range of database application are given below: 1- Personal Database 2- Workgroup Database 3- Department Database 4- Enterprise Database
What is active database and cloud database?
The database we use in our daily life is called as active database . The data that is stored in the database which is further stored on the cloud is called cloud database.
How is a database structured?
database structure depends on the business requirement and size of database. database structure depends on the business requirement and size of database.
Is a dhcp database a distributed database similar to a dns database?
no
Is the relational database an example of oracle database?
A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.
Why do Database Management is related to MS Access?
Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.
Data base state vs database schema?
The database schema is the description of the database. It defines how the database is set up and what data it is to contain and control. This description is given to the DBMS to manage the data. The database state is an image of how the database looks at any given time. The database schema is set unless you change how the database is structured. The database state will change whenever new data is entered into the database and the database is updated.
Difference between database and relational database?
A relational database is a type of database, so in one sense there is no difference. There are various kinds of database. A relational database is one type. Others include network and hierarchical.
