Functional relational database

The signature assignment is aimed at testing student proficiency in this course across various offerings of this course. The signature assignment tests the course learning outcomes. Create a fully functional relational database that able to demonstrate the requirements of an XYZ company. Logical design of the database documents Create physical design with the following features The design must be in BoyceCodd normal form. Each table must have keys – primary, foreign keys Create Integrity Constraints Populate each table with data at least 10 rows (do not disable the constraints) Be able to insert, update, delete, and select from table (DML) Generate scripts and data to be inserted and put them in a file (use notepad) with extension of “.sql”. The format of the file should be lastname_firstname_SWE560Summer2017.sql. Zip it up and upload it to EMS. Along with the zip file includes your Entity-Relationship Diagram documentation. Note: [login to view URL] DDL should be free of error. [login to view URL] integrity constraints should enforce the rules on the data being inserted.