1 / 41

Comprehensive Guide to Database Fundamentals

Understand Database Concepts, Relationships, and Data Entry Methods. Learn about Raw Data vs Processed Information in Computer Systems. Explore Primary and Foreign Keys, Validation Checks, and Data Types.

oakes
Télécharger la présentation

Comprehensive Guide to Database Fundamentals

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATABASE RC FF R CMA UI M RD F PK E F VC H S RC N H A V FK

  2. WHAT D IS RAW, UNPROCESSED FACTS AND FIGURES COLLECTED, STORED AND PROCESSED BY COMPUTERS. ANSWER

  3. DATA

  4. WHAT A DESCRIBES INFORMATION BELONGING TO AN ENTITY ANSWER

  5. ATTRIBUTE

  6. WHAT FF IS A DATABASE WHERE ALL THE DATA IS HELD IN A SINGLE TABLE AND STORED AS A SINGLE FILE ANSWER

  7. FLAT FILE

  8. WHAT E REPRESENTS A PERSON OR OBJECT ANSWER

  9. ENTITY

  10. WHAT PK IS THE FIELD THAT UNIQUELY IDENTIFIES ONE RECORD FROM ALL OTHER RECORDS IN A DATABASE ANSWER

  11. PRIMARY KEY

  12. WHAT FK IS A FIELD WHICH IS A PRIMARY KEY IN ANOTHER TABLE ANSWER

  13. FOREIGN KEY

  14. WHAT F IS AN OBJECT USED TO ENTER NEW DATA INTO A RELATIONAL DATABASE? ANSWER

  15. FORM

  16. WHAT RC IS A VALIDATION CHECK THAT CAN BE PERFORMED ON DATA ANSWER

  17. RESTRICTED CHOICE

  18. WHAT F IN A DATABASE REPRESENTS A COLUMN IN A TABLE ANSWER

  19. FIELD

  20. WHAT RC IS A VALIDATION CHECK THAT CAN BE PERFORMED ON DATA USUALLY BETWEEN TWO LIMITS EG 1-100 ANSWER

  21. RANGE CHECK

  22. WHAT RD IS WHERE TWO OR MORE TABLES ARE LINKED BY SHARING A COMMON ATTRIBUTE ANSWER

  23. RELATIONAL DATABASE

  24. WHAT V IS TO MAKE SURE THE DATE IS CORRECT ANSWER

  25. VERIFY

  26. ANSWER WHAT H IS A TYPE OF FILING SYSTEM THAT LOOKS SIMILAR TO THE DIAGRAM BELOW

  27. HIERARCHICAL

  28. WHAT M IS A TYPE OF DATABASE THAT CONTAINS TEXT, SOUND, VIDEO, ANIMATION AND GRAPHICS ANSWER

  29. MULTIMEDIA

  30. WHAT H IS AN OFFENCE UNDER THE COMPUTER MISUSE ACT ANSWER

  31. HACKING

  32. WHAT R IS THE NAME GIVEN TO THE LINK BETWEEN 2 TABLES ANSWER

  33. RELATIONSHIP

  34. WHAT VC CONTROLS THE WAY DATA IS ENTERED INTO A DATABASE ANSWER

  35. VALIDATION CHECK

  36. WHAT S ALLOWS YOU TO FIND CERTAIN RECORDS IN A DATABASE BY SELECTING THE CRITERIA TO LOOK FOR ANSWER

  37. SEARCH

  38. WHAT CMA IS A LAW WHICH ALLOWS COMPUTER CRIMINALS LIKE THE CREATORS OF VIRUSES TO BE PROSECUTED ANSWER

  39. COMPUTER MISUSE ACT

  40. WHAT UIALLOWS FOR THE EASY ENTRY, RETRIEVAL, MODIFICATION AND OUTPUT OF DATA ANSWER

  41. USER INTERFACE

More Related