SQL
Structured Query Language or SQL is a standard database language used to create, maintain and retrieve data from relational databases such as MySQL, Oracle, SQL Server, PostGre, etc. The recent ISO standard version of SQL is SQL: 2019. As the name suggests, it is used when we have structured data (in the form of tables). All databases that are not relational (or that do not use fixed structure tables to store data) and therefore do not use SQL, are called NoSQL databases. Examples of NoSQL are MongoDB, DynamoDB, Cassandra, etc.
PROJECT IDEAS
Database interface for LabVIEW Robotic Control
LabVIEW is a dynamic tool that uses data to modify the operational parameters of a robot, depending on different conditions. To do this, the data must be stored in such a way that the program can easily access it. Therefore, database interfaces are developed to facilitate efficient communication. SQL queries within the database enable convenient, structured data storage and retrieval, which in turn improves the robot’s functionality.
SMS-based remote server monitoring system
These systems are particularly beneficial for large corporate organizations that have massive data centers and multiple servers. Since these servers host a large number of applications, it is difficult to monitor their functionality. Typically, when a server is down or crashed, clients inform the organization about it.
To avoid delays in corrective actions, you need a web-based solution that can remotely monitor these server failures. Such an application would periodically ping the servers based on predetermined rules, and then send an SMS to a predetermined list of specialists in case a server is down. This message would contain specific details about the server, the time of failure, etc.
Blood Donation Database
This database would store interrelated data on patients, blood donors, and blood banks. You can follow the example of the data points listed below.
Patient name, unique identification, blood group and disease
Donor name, unique identification, blood group, medical report, address, contact number
Name of the blood bank, address, donor details of the blood bank (name, address, contact number)
Now, try to implement the same in a database by creating a schema, an Entity-Relationship (E-R) diagram, and then try to normalize it.
Hospital Management System
It is a web-based system or software that allows you to manage the operation of a hospital or any other medical facility. Creates a systematic and standardized registry of patients, doctors and rooms, which can only be controlled by the administrator. All patients and doctors will have a unique one and will be related in the database based on the treatments in progress. In addition, there will be separate modules for hospital admission, patient discharge summary, roles of nurses and ward boys, medical stores, etc.
Centralized university database
A university has academic departments, such as the Department of English, the Department of Mathematics, the Department of History, etc. And each department offers a variety of courses. Now an instructor can teach more than one course. Let’s say a teacher takes a class in Statistics and also in Calculus.
As a student in the Mathematics department, you can enroll in both courses. Therefore, each university course can have any number of students. Here an important point to keep in mind is that a particular course can have only one instructor to avoid overlaps.
Student database management
Similarly, you can do a student record keeping project. The database would contain general student information (such as name, address, contact information, year of admission, courses, etc.), attendance file, grades or results file, fee file, scholarship file, etc. An automated student database streamlines the college administration process to a considerable degree.
SOURCE TO LERAN SQL
https://www.w3schools.com/sql/default.asp
Also Read,