This Oracle SQL folder has the sql files and also sql queries used to developed database using SQL
- Conceptual schema (assignment 1 - CPHC ERD visio diagram ) and Logical Schema Design: Transformed the conceptual schema into a 3NF logical schema for CPHC and specified integrity constraints.(assignment 2) 2.Query Formulation: Developed relational algebra and tuple relational calculus queries to retrieve employee data based on specified criteria.(assignment 2) 3.Normalization of a Big Table: Identified data redundancies and anomalies, determined primary keys and normal form, and normalized the table into3NF with clear primary and foreign key definitions implementing database normalization concepts.(assignment 2)
- Database creation: Created the database for Continental Palms Hardware Company (CPHC) in Oracle and entered data(assignment 3)
- Query Formulation : Had run some CRUD queries to check that the database operations are smooth(assignment 3)
- Used PLSQL to create a scenario based function, trigger and procedure for sales employees tables(assignment 4 )
- Developed a vpn-microsoft access server connection based html page to mimic how customers would use CPHC hardware company to place orders
- Data warehousing and OLAP transaction management : Created a data warehouse in Oracle based on the following star schema provided as per the use case, entered sample data and had run sample OLAP queries (assignment 6 file)
This MySQL folder has a Employee database java files used to create a MySQL database with jdbc connectivity developed in JAVA JDBC (Java Database Connectivity) is a Java API that allows Java applications to interact with various databases, including MySQL. JDBC provides a standard interface for connecting Java applications to relational databases, executing SQL queries, and manipulating data. It acts as a bridge between Java programming language and databases like MySQL, enabling developers to write database applications in Java that are portable across different database systems. In essence, JDBC facilitates seamless communication and interaction between Java applications and MySQL databases, enabling tasks such as querying, updating, and managing relational data. The whole application was developed using Java with database driver connection and data queries were run using mysql