JS not enabled Databases Features and Elements - Daily Manchester
  • Databases Features and Elements
Databases  Features and Elements

What is a flat- file database?

Database is when not being used into the stored on the computer system to save your files, programs …etc. the flat fil is all data where you going to store one single file into database and it is good for small task to use the data in your compute, and the it is must be read in its entirety into the computer’s memory.

What is relational database?

The relational database is opposite flat file its set of tables containing data fitted into predefined categories. Relational database is makes the data reputing and make it have more storage into the computer.

Flat-file a versus relational

The flat file it is easy to and it’s designed around a single table. The relational it good and it stored more data then flat-file and it can designed around all table into the computer and its can data more tables then the flat-file.

What is a primary key?

The primary key it is also called the primary keyword. And it is a key of the relational database at is unique for each record. It is a unique identifier, for example the national insurances number, telephone number…. etc. A relational database must always have one and only one primary key.

What is the foreign key?

The foreign key is only the reflection for the primary key and we need it to reflections the database and share information, the foreign key it is field in one table that uniquely identifies a row of another table. The foreign key is defined in a second table, but it refers to the primary key in the first table.

What is a database table?

relational databases and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect.

Explain what is a database relationship is

  A relationship exists between two database tables when one table has a foreign key that references the primary key of another table.

Describe what a data type is

The data types are the information you put inside the database for example the the primary key and the foreign key in formation they are all a data types

What is database query

Select query is just the query data retrieval. Action query can ask for additional operations on the data, such as the insertion, and updated, or deleted. And it called the language used to interact with the data query languages rules, and that of Structured Query Language (SQL) is a known standard.

What are database reports used for

The database report shows the information in profissnal way, and database report presents information from a database. Information is displayed simply and efficiently. Reports can be printed from the database to view information quickly and easily.


Explain what referential integrity is

Referential integrity is the concept of the database that can be relationships between tables remain constant. When one table a foreign key to another table, the concept of referential integrity states that you may not add a record to the table containing the foreign key unless there is a corresponding record in the related table