Client-server database Flashcards
What do client-server database work?
The client–server database is a multi-user system that allows several clients to access the database simultaneously.
How does a client-sever model work?
The client–server database model has become one of the central ideas of network computing. The database is installed and maintained on a server and the client is considered to be a user who accesses the database from one of many workstations on the network.
What does database management system (DBMS) software application designed do?
to interact with database users
* to capture, extract and analyse data
* to interact with other software applications
What is DBMS used to create?
DBMS software is used to create a database, capture, select and retrieve data, as well as exchanging data with other applications
What is database structure used to create?
- A database structure can be created including linking tables to form relationships and to create a user interface to access the elements of the database. Many DBMS systems automatically create documentation for the system.
DBMS - What are tables used for?
Tables are used to store data which can be captured by a data entry form or by importing data from another database in a range of formats, such as CSV files.
DBMS - What are queries used for?
Queries are mainly used to retrieve specific data from a table or tables; where this data is stored in more than one table a complex query will process the data into a single datasheet
DBMS - What are reports used for?
Reports are used to summarise and present the data that is in the tables. A report is usually required for a specific issue, such as ‘list details for each customer account this month
What does a DBMS system follow?
Provides for a centralised automatic backup of the system.
* Assign different types of database user with associated access rights.
* Provide logon and password facilities for users.
* Update of DBMS programs and development of associated software tools
What is an advantage of DMBS?
In a DBMS the data is separated from the applications that access it, so programs work independently of the data; the main advantage of this is that database administrators can modify the software tools that control the database, but the data will remain unchanged by these programs.
