Class- 8th Introduction to relational database

 Class- 8th 

Important Full Forms of Computer Technology

Hardware Components

1.     CPU - Central Processing Unit  

2.     GPU - Graphics Processing Unit  

3.     SSD - Solid State Drive  

4.     HDD - Hard Disk Drive  

5.     NIC - Network Interface Card  

6.     MAC - Media Access Control  

7.     BIOS - Basic Input Output System  

8.     PCB - Printed Circuit Board  

9.     CRT - Cathode Ray Tube  

10.     OLED - Organic Light-Emitting Diode  

11.     VGA - Video Graphics Array  

12.     SVGA - Super Video Graphics Array  

 Networking 

13.     LAN - Local Area Network  

14.     WAN - Wide Area Network  

15.     MAN - Metropolitan Area Network  

16.     PAN - Personal Area Network  

17.     WLAN - Wireless Local Area Network  

18.     SAN - Storage Area Network  

19.     CAN - Campus Area Network  

20.     VPN - Virtual Private Network  

21.     VLAN - Virtual Local Area Network  

22.     ISP - Internet Service Provider  

23.     DNS - Domain Name System  

24.     DHCP - Dynamic Host Configuration Protocol  

25.     TCP - Transmission Control Protocol  

26.     UDP - User Datagram Protocol  

27.     SNMP - Simple Network Management Protocol  

28.     ICMP - Internet Control Message Protocol  

29.     NAT - Network Address Translation  

---

Programming & Software

30.     API - Application Programming Interface  

31.     GUI - Graphical User Interface  

32.     CLI - Command Line Interface  

33.     SDK - Software Development Kit  

34.     JVM - Java Virtual Machine  

35.     JRE - Java Runtime Environment  

36.     XML - Extensible Markup Language  

37.     HTML - Hypertext Markup Language  

38.     SQL - Structured Query Language  

39.     OOP - Object-Oriented Programming  

40.     SaaS - Software as a Service  

41.     PaaS - Platform as a Service  

42.     IaaS - Infrastructure as a Service  

 Storage & Data Transfer

43.     RAM - Random Access Memory  

44.     ROM - Read-Only Memory  

45.     USB - Universal Serial Bus  

46.     DPI - Dots Per Inch  

47.     MB - Megabyte  

48.     GB - Gigabyte  

49.     TB - Terabyte  

50.     PB - Petabyte  

51.     EB - Exabyte  

52.     ZB - Zettabyte  

53.     YB - Yottabyte  

54.     KB - Kilobyte  

55.     bps - Bits Per Second  

56.     KBps - Kilobytes Per Second  

57.     MBps - Megabytes Per Second  

58.     GBps - Gigabytes Per Second  

59.     Tbps - Terabits Per Second  

60.     IOPS - Input/Output Operations Per Second  

61.     RPM - Revolutions Per Minute  

Security & Protocols

62.     SSL - Secure Sockets Layer  

63.     TLS - Transport Layer Security  

64.     HTTPS - Hypertext Transfer Protocol Secure  

65.     WEP - Wired Equivalent Privacy  

66.     WPA - Wi-Fi Protected Access  

67.     IDS - Intrusion Detection System  

68.     IPS - Intrusion Prevention System  

Miscellaneous

69.     AI - Artificial Intelligence  

70.     ML - Machine Learning  

71.     IoT - Internet of Things  

72.     ASCII - American Standard Code for Information Interchange  

73.     GSM - Global System for Mobile Communications  

74.     ERP - Enterprise Resource Planning  

75.     CRM - Customer Relationship Management  

76.     OCR - Optical Character Recognition  

77.     MICR - Magnetic Ink Character Recognition  

78.     MIDI - Musical Instrument Digital Interface  

79.     COMPUTER (Common Operating Machine Purposely Used for Technical Education Research) 

80.     IPv6 - Internet Protocol version 6  

81.     CD-ROM - Compact Disc Read-Only Memory  

82.     DVD - Digital Versatile Disc  

83.     FTP - File Transfer Protocol  

84.    HTTP - Hypertext Transfer Protocol  

85.     TFTP - Trivial File Transfer Protocol  

86.     IVR - Interactive Voice Response  

87.     RAID - Redundant Array of Independent Disks  

88.     SCSI - Small Computer System Interface  

89.     UEFI - Unified Extensible Firmware Interface  

90.     VR - Virtual Reality  

91.     WYSIWYG - What You See Is What You Get  

92.     Virus - Vital Information Resources Under Siege

93.     RAT - Remote Access Trojan

94.     WORM - Write Once Read Many

95.     SMTP - Simple Mail Transfer Protocol

96.    FDD - Floppy Disk Drive

97.    FAT - File Allocation Table

98.    FAQ - Frequently Asked Questions

99.    MS - Microsoft 

100.  FIFO - First In First Out

Important Shortcut key for Computer Window

1.    Ctrl + Shift + N: Create a new folder.

2.   Ctrl + C: Copy selected text or item

3.   Ctrl + X: Cut selected text or item

4.   Ctrl + V: Paste copied or cut text or item

5.   Ctrl + Z: Undo previous action

6.   Ctrl + A: Select all text or items

7.   Ctrl + F: Find a specific word.

8.  Ctrl + S: Save document or file

9.  Ctrl + N: Open a new document or file

10.  Ctrl + O: Open an existing document or file

11. Ctrl + P: Print the current document or file

12. Alt + Tab: Switch between open windows or applications

13.  Windows key + L: Lock the computer

14.  Windows key + D: Show or hide the desktop

15.  Windows key + E: Open File Explorer

16.  Windows key + R: Open the Run dialog box

17.  F1: Open help Window

18.  F5: Refresh the current webpage 

19.  Ctrl + Alt + Delete: Open Task Manager

20.  Alt + F4 : Closed running program 

Basic Questions and answers related to computer

Q.1    What is computer? 

Ans:-     Computer is an electronic device that transforms data meaningful information. 

Q.2    Who is the father of computer? 

Ans:-     Charles Babbage 

Q.3    What do you mean by hardware and software? 

Ans:-    Software:- The programs and instruction that tells the computer what to do.

Hardware:- The Physical part of computer that can be seen and touch.

Chapter- 1     Introduction to relational database

Exercise 

A.  Multiple Choice Questions 

1. d)  4

2. a) Information 

3. b) relation 

4. c) data redundancy 

5. b) data syncing 

B. Fill in the blanks 

1.    Data security 

2.    Information 

3.     SQL Server 

4.    Data Privacy 

5.    SQL

 

C.    True or False 

1.     True 

2.     False 

3.     True 

4.     True 

5.      False 

Key Vocabulary

Data: Raw facts which alone are meaningless.

Information: Facts related logically give us meaningful information. 

Database: Organised collection of data.

RDBMS: Application software used to create and manage databases.

Relation: Another name for database table.

Data redundancy: Multiple copies of same data.

SQL: Structured Query language used to work with databases

A.    Answer the following questions in short 

Q.1    What is database ? 

Ans:-     A database is an organized collection of data that is stored and accessed electronically. It is designed to efficiently store, manage, retrieve, and update information.

Q.2    How does DBMS help us ? 

Ans:-    A Database Management System(DBMS) helps organise data, making it easier to update, retrieve , and protect , improving efficiency and accuracy.

Q.3    How many types of databases are there?

Ans:-    The two main types of databases are Flat File Database and Relational Database.

B.    Answer the following questions in long. 

 Q.1    With a small example, give basic difference between "data" and "information."

Ans-     Data are the raw pieces of information which has no sense but information are organised or structured data that is meaningful and useful.

    Example- Data- 25 celsius, Hamirpur.

    Information- Temperature in hamirpur is 25 celsius.

Q.2    List the name of any 4 popular database.

Ans -  1. My SQL - Open source widely used for web apps.

            2- Postgre SQL - Advanced Open source known for reliability.

            3- Oracle Database - Commercial used in large enterprise.

            4- Microsoft SQL server - commercial, integrates well with windows.

Q3- List any 4 advantage of a database manegment system and briefly describe any two of them.

Ans:-    Advantages of DBMS:- 

1.    Reduces data redundancy 

2.    Improves data security

3.    Enables data sharing

4.    Provides data backup and recovery

Brief Description of - 

1.     Reduces data redundancy:-     A DBMS stores data in a centralized manner, 

    so the same data does not need to be repeated in many places. This saves 

    storage space and avoids duplication.

2. Improves data security:- A DBMS allows only authorized users to access or modify data using passwords and permissions, helping keep information safe.

Q.4        What is Relational Database Management System (RDBMS)? 

Ans:-    A software application that allows to create databases, store data in them and perform all the tasks related to manage the data is called relational database management system.

Q.5        What is the role of SQL in database ? 

Ans:-     Structured Query Language: All RDBMSs in the industries have the same language to maintain and manage the data. This language is called Structured Query Language (SQL). SQL is a collection of database commands to create databases, tables and work with the data.