Skip to content

idreesally/SQL-Server-Recreate-Star-Schema

Repository files navigation

• Create one stored procedure that will trigger a chain of other stored procedures.

• Truncate all tables within the database, except for one table which contains all of the originally loaded data.

• Create multiple stored procedures that will recreate all tables of the database, as well as set primary and foreign keys to maintain the relationships between the tables.

• Create two new tables that will connect to one of the original tables using a Grandparent to parent to child relationship.

https://drive.google.com/file/d/1uoAGFhN6hh-Izk5jwEt3rh037Jdw_AR4/view?usp=sharing

About

Group Project for Recreating the Star Schema of the BIClass Database

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published