Database Project

Datasbase project that fulfills all the requirements mentioned below and in the document. It should also include a UI to see the data in the database. Please give priority to database normalization. The database project should contain the following requirements: • It should have the Business Rules defined • It should have all the entities in place according to Business rules • It should demonstrate entity relationships through different types (One to many, one-to-one or one to many). • It should have all the tables defined (together with data types, keys, indexes). • It should be able to demonstrate some querying and reporting functionalities (able to produce reports based on existent tables). • It should provide data entry capabilities (Insert, Update and Delete) for user through properly designed interface (forms or web forms or any interface through capability). Stages of implementation Logical design which should consider the following aspects: • Business Rules Definition • Entity Relationship Diagram (ERD) • Entity constrains (Entity Integrity, referential integrity and cardinalities (optional)) • Database Normalization (up to 3rd Normal Form 3NF) Physical Design which should be consisted of the following aspects: • Naming conventions for tables, columns and data types. • Primary Keys (PK) and Foreign Keys (FK) used. • Relationships implemented. • Demonstrating some query functionalities of your database. Illustrating some reporting use cases. • Form functionality for data entry (your can use other application and connect it to your database if you like.