his semester we will create a database solution for AcmeMatch Inc. The company matches their customers based on the following criteria:

Age group

Gender

Education level

Interests

It has three departments:

Customer accusation that enrolls users and collects their information.

Billing that charges customers based on number of found matches. The price for the first 10 matches is higher than for the next matches.

Individual Project Grading Criteria

For your individual project, you will use Oracle or MS SQL Server to

Design a database for AcmeMatch Inc with at least three tables and no more than seven. Each table must have at least a primary and foreign key if applicable.

At least three user categories are defined to use the AcmeMatch Inc database.

Ordinary users (input their information and update it)

database owner (all permissions)

Billing department employees.

Trigger that generates billing for each match found.

Write SQL statement for each table in MS SQL