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
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
The Director Ioannis Ntizoglou has a vision: FREE News for everyone! No agenda and always the Real News in Manchester. Daily Manchester News, Manchester Day News, Manchester Evening News and Manchester Night News. The daily News you will see and read here are not fake news.
DailyManchester.co.uk doesn’t support any political party and this is one of the reasons everyone can trust our stories.