Device manufacturer database
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. Roles / Responsibilities
built database structure for product movement on a global level.
normalized the database.
created tables, views, procedures, functions, triggers, and indexes.
maintained data to be tracked at any point in time.
created a list of queries in a separate table which can be fired by channel partners, distributors, production houses, etc.
collected customer identification.
tracked the whole history of the product.
increased price based on the distribution chain.
customer can return faulty products to production house (through same transport chain as it went through)
Environment / Technologies T-Sql, Sql Server Integration Services, Microsoft SQL Server Management Studio, Visual Studio SSDT