Universities Catalog Database

This database was built and developed through Windows Powershell SQL with AWS Database network connection.

Worked collaboratively in a two person team to develop a University database for a publishing company using only their university catalog. The goal is to accurately model the real-world scenario (student) in a way that is both efficient and reflects all business rules. Identifying the semantics of the data is the first step. For instance, entities in a student housing database might include: Students: Information about the students (name, ID, contact details). Housing Units: Details about each housing unit (unit name, type, capacity). Accreditations (description). With all the information a university has to offer we picked out all the semantic rules. After creating dependencies for our semantic rules we designed and normalized the information into an AWS database using SQL. For further detail, testing and implementation visit my project on my portfolio: University Catalog Database