There are so many electronic device manufacturers like Apple Inc has a global presence and has multiple products been produced and supplied across the world. My role as DB Developer is to design a database system, present the ER diagram for the same, normalize the tables and make It productive. Any data can be tracked at any point of time. Recommend and design appropriate various database objects like tables, views, procedures, functions, triggers, indexes. Create a list of queries in a separate table which can be fired by channel partners, distributors, production houses, Zone manager etc.
- SQL DataBase
- T-SQL
- Sql Server Integration Services
- Creating products
- Ordering Products
- Returning Products
- Moving products in the distribution chain
- Multiple views
Clone repo: https://github.com/210104-msbi-reston/BryanBlueP1.git Load the backup file onto your SQL server to get the database setup.
Use the demo file to for example queries/stored procedures