cse414 - Databases - Project Assignment  -Solved

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.