How aljolandaalhandhali/database works
This repository is a collection of database coursework and an EMS database capstone, not a conventional application with a demonstrated user-facing runtime. The clearest implementation workflow is schema definition and data manipulation, alongside query, reporting, and database-programming materials. The README is only a title and no source excerpts were supplied, so connections beyond the operations indicated by filenames are omitted.
Main entry points: DDL.sql Schema definition · DML.sql Data manipulation · Views.sql Views · StoredProceduresAndFunctions.sql Procedures and functions
Components 20
EMS database
- Schema definition
EMSDatabaseProject/Implementation/DDL.sql - Data manipulation
EMSDatabaseProject/Implementation/DML.sql - Views
EMSDatabaseProject/Implementation/Views.sql - Procedures and functions
EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql - Triggers
EMSDatabaseProject/Implementation/Triggers.sql - Scheduled jobs
EMSDatabaseProject/Implementation/OracleSchedulerJobs.sql - Capstone overview
EMSDatabaseProject/CapstoneProject.pdf
Query and reporting
- Join queries
EMSDatabaseProject/Implementation/Joins.sql - Subqueries
EMSDatabaseProject/Implementation/Subqueries.sql - Aggregation functions
EMSDatabaseProject/Implementation/AggregationFunctions.sql
Database coursework
- Join practice
JOINPracticeTask/OracleHRSchemaJOINPracticeTask.pdf - Subquery analytics
SubqueryAnalyticsAndBusinessReporting/SubqueriesAnalyticalReports.pdf - Query logic review
SubqueryLogicReviewAndExecutionAnalysis/SubqueryLogicReviewAndExecutionAnalysis.pdf - Query validation
QueryLogicValidation/CodeReviewAndQueryLogicValidation.pdf - SQL join study
SQLJOINImplementation/SQLJOINImplementation.pdf - Set operations
SQLSetOperationsResearch/SQLSetOperations.pdf - Enterprise assignment
EnterpriseDatabaseEngineeringAssignment/Assignment.pdf - Database investigation
reports/Database-Investigation.pdf
Other components
- Database engineer
- Oracle database
Connections 9
- Schema definition → Oracle database: defines schema
- Data manipulation → Oracle database: manipulates data
- Views → Oracle database: defines views
- Procedures and functions → Oracle database: defines routines
- Triggers → Oracle database: defines triggers
- Scheduled jobs → Oracle database: defines jobs
- Join queries → Oracle database: queries data
- Subqueries → Oracle database: queries data
- Aggregation functions → Oracle database: aggregates data