Welcome to
Visitors
ESC | Feedback | Question | Exam Centres
language
We are taking extra measures to ensure your children are safe. Learn more
Engineering:
-
The branch of science and technology concerned with the design, building, and use of engines, machines, and structures.
-
Engineer's business
-
Mechanics
Echofriendly interest: Computer / Chemical / Mechanical / Environment / Civil / BioTechnology / Instrumentation
What is Chemical?
What is Mechanical?
What is Environment?
What is BioTechnology?
What is Civil?
What is Computer Science?
Computer Science is the study of computers and computational systems. Unlike electrical and computer engineers, computer scientists deal mostly with software and software systems; This includes their theory, design, development, and application.
Principal areas of study within Computer Science include artificial intelligence, computer systems, and networks, security, database systems, human-computer interaction, vision and graphics, numerical analysis, programming languages, software engineering, bioinformatics, and computing theory.
Although knowing how to program is essential to the study of computer science, it is only one element of the field. Computer scientists design and analyze algorithms to solve programs and study the performance of computer hardware and software. The problems that computer scientists encounter range from the abstract-- determining what problems can be solved with computers and the complexity of the algorithms that solve them - to the tangible - designing applications that perform well on handheld devices, that are easy to use, and that uphold security measures.
Graduates of the University of Maryland's Computer Science Department are lifetime learners; they are able to adapt quickly with this challenging field.
Computer
DATABASE MANAGEMENT
A Database Management System (DBMS) is software that allows users to define, create, store, retrieve, update, and manage data within a database. It acts as an interface between users and the database, providing tools for efficient and organized data handling.
Here's a more detailed explanation:
Key Functions of a DBMS:
-
Data Storage:
Storing the actual data in the database in an organized manner.
-
Data Manipulation:
Allowing users to add, update, delete, and retrieve data from the database.
-
Data Security:
Providing mechanisms for user authentication, authorization, and access control to protect sensitive data.
-
Data Integrity:
Ensuring data accuracy and consistency through constraints and validation rules.
-
Data Concurrency:
Managing simultaneous access to the database by multiple users, preventing conflicts and ensuring data consistency.
-
Backup and Recovery:
Enabling regular backups of the database and providing mechanisms for restoring data in case of failures.
-
Data Definition:
Defining the structure of the database, including tables, columns, data types, and relationships between data.
Types of DBMS:
-
Relational DBMS (RDBMS): Organizes data into tables with rows and columns, using SQL for data manipulation. Examples include MySQL, Oracle, and SQL Server.
-
Object-Oriented DBMS (OODBMS): Stores data as objects, allowing for complex data types and relationships.
-
NoSQL DBMS: A broad category of non-relational databases that handle large volumes of unstructured and semi-structured data. Examples include MongoDB and Cassandra.
Examples of DBMS:
-
MySQL: A popular open-source RDBMS.
-
Oracle: A commercial RDBMS known for its scalability and features.
-
SQL Server: A Microsoft RDBMS.
-
PostgreSQL: An open-source RDBMS known for its robustness and advanced features.
-
MongoDB: A popular NoSQL database.
Advantages of using a DBMS:
-
Improved Data Management: Provides efficient storage, retrieval, and manipulation of data.
-
Enhanced Data Integrity: Enforces data validation rules and constraints, ensuring data accuracy.
-
Increased Data Security: Protects data from unauthorized access and manipulation.
-
Reduced Data Redundancy: Eliminates duplication of data, saving storage space and improving consistency.
-
Improved Data Sharing and Collaboration: Enables multiple users to access and share data simultaneously.
-
Support for Complex Data Relationships: Facilitates the modeling and querying of complex data relationships.