The Spectra Lab Management System, integrates SQL Server with a Visual Basic GUI to manage medical lab operations. Developed by a multidisciplinary team, it enhances efficiency and accuracy in patient care through advanced technologies and streamlined processes.

Database Management Information System

This project aims to design and develop a database management information system for a specific domain. The project will involve:

• Identifying a real-world use case for a relational database
• Defining the functional requirements for the database
• Designing the database schema
• Developing the logical specifications
• Building and populating the database
• Creating queries and views to demonstrate the database's capabilities
• Developing a graphical user interface (GUI) for user interaction

Tools and Technologies

• Microsoft SQL Server Management System (SSMS)
• Microsoft Visual Basic (.NET)
• Microsoft Word & Excel
• ER diagramming tools: lucid.app or erdplus.com
• Online resources: Stack Overflow (www.Stackflow.com)
• Free image resources: Freepik.com
• Color scheme inspiration: colorsinspo.com

Connecting to the Database

Creating the Database from the lab3.sql file

• Create the database: Use SQL Server Management Studio (SSMS) to create a new database named lab3.
• Populate the database: Execute the SQL script lab3.sql in SSMS to populate the database with necessary tables and data.
• Connecting VB.NET to the Database
• Open database.vb: Locate the database.vb file in your project.
• Modify the connection string: Edit the sqlcon variable's value in the database module to match your SSMS server name.
• Replace "Add Your Server Name on SSMS eg: Legion-5\SQLEXPRESS" with the actual name of your server.
• Ensure the correct authentication method (Windows Authentication or SQL Server Authentication) is used.

Example:

Public sqlcon As New SqlConnection("server=YOUR_SERVER_NAME;database=lab3;Integrated Security=True")

Use code with caution.

• Build and run the application: Compile and run your VB.NET application.
• Note: Replace YOUR_SERVER_NAME with the actual name of your SQL Server instance.

Visuals:

Database Schema Visualization

ER Diagram

Relational Model

GUI Interface Design

Login Page

Admin Page

Staff Data Display Page

User Login Page

User Test Results Page using Request ID

License Agreement

This project is licensed under the License Agreement. See the LICENSE.md file for details.