Flashcards
Database
Flashcards do conjunto (28)
- 1Flat fileAll the data is held in one table
- 20 NFAn unnormalised data base
- 3NormalisationA process used to come up with the best possible design for a database
- 41 NFA table is in first normal form if it contains no repeating attributes or groups of attributes
- 52 NFA table is in second normal form if it is in first normal form and contains no partial dependencies
- 63NFA table is in third normal form if it s second normal form and contains no non-key dependencies
- 7E-R diagramA diagram that can show the relationships between elements in the database
- 8Foreign keyA foreign key is an attribute that creates a join between two tables
- 9Composite primary keyThe key of the Environment table consists of the two fields
- 10Advantages of normalisationEasier to maintain and change a normalised database
No unnecessary duplication data
Faster searches and less storage - 11SQRStructured Query Language
- 12SELECTlist of fields to be displayed
- 13FROMlist the table or tables the data will come from
- 14WHERElist of search criteria
- 15ORDER BYlist the fields that the data is to be sorted on
- 16BETWEENbetween an inclusive
- 17INspecify multiple possible values for a column
- 18CREATE TABLETo create a table
- 19ALTER TABLEStatement used to add, delete or modify columns in an existing table
- 20Client-Server databaseDatabase Management System(DBMS) software on the server processes requests for clients, which are individual workstations
- 21Record lockingIt prevents simultaneous access to objects in a database in order to prevent updates being lost or inconsistencies in the data arising
- 22SerialisationIt is an alternative technique used to ensure that transaction do not overlap in time
- 23Timestamp orderingIf the read timestamp is not the same as it was when they started the transaction, the DBMS know another users has accessed the same object
- 24Commitment orderingIt orders the terms of their dependencies on one another as well as the time they were initiated
- 25Agile approachTo get constant feedback from the user throughout the development of a new system
- 26Modelling data requirementsThe data required of a new system needs to be organised and related in such a way that it represents the real world as closely as possible
- 27TestingModule testing
System testing
Acceptance testing - 28EvaluationIt allows users to evaluate the system on the basis of effectiveness, usability and maintainability
Informações
- Descrição
- absolutely nothing Assassination FlashCards sobre Database, criado por aaa aaa em 15-02-2019.
- Criado por
- aaa aaa
- Visualizações
- 0
- Tags
- Avaliação