SOLVED CSE 414 Databases Project Assignment

 Suppose that you have a company. You want to create the database of your company. ▪ Describe the user requirements of your company. ▪ Draw the E-R diagram of the company. ▪ Do normalization. ▪ List the functional dependencies. ▪ List your tables. ▪ Create the database including everything (tables, relationships, keys etc.). You may use any database management system. ▪ Create the user interface of at least 5 modules using any programming language. Choose the interfaces according to the questions below. ▪ Create 1 OUTER RIGHT JOIN, 1 OUTER LEFT JOIN, 1 FULL OUTER JOIN queries on user interface. ▪ Create and use at least 5 different triggers making completely different tasks. Show how they are working in your interfaces. ▪ Create and use at least 5 different views that are completely different from each other. Show how they are working in your interface. Additional: ▪ Give and create at least 3 atomic transactions. ▪ For at least 3 tasks solve concurrency of transactions using any techniques in the book. ▪ Add additional details about the database if there is any. ▪ Use inheritance for the tables. Note: ▪ Your E-R diagram should be as complex as the E-R diagram of student managements system example in the book. Which means, it should have many entities and relations.