I am trying to figure out the Merged ERD's as well the Initial tables Marks. $8\%$ of tinal grade $($marked out of $20$ Late Labs WIII NO be accepted Stuff B Gone $$ SALE in Consignment Services Objectives $1.$ Produce an ERD in $3$NF from source documents and client input. $2.$ Demonstrate initial table, first, second, and third normal forms by showing the database tables as they exist in each of the three normal forms $3.$ Merge ERDs from different views to create one final merged ERD Requirements Given the source documents and company description create a database design demonstrating the concept of normalization, showing all the attributes as they exist in the initial table, $1$NF$,2$NF$,$ and $3$NF$.$ You will do this for each of the three views and create an ERD for each view in $3$NF$,$ as well as the final merged ERD. The Company Stuff B Gone is a company that sells customers items for them. In return for this service they collect a fee for each item they sell for the customer. Currently Stuff B Gone sells customers items through physical stores, Facebook groups$/$Marketplace$,$ and Kijiji. As an incentive to thank repeat customers, they have a reward program where customers can get discounts on their consignments. In order to provide the best experience for the customers, all staff are able to take training where they can improve their skills.Marks: $8\%$ of final grade $($marked out of $20)$ Late Labs will NOT be accepted Consignment Agreement View $(7$ marks$)$ Consignment ID: $255$ Date: Jan $20,2022$ Customer ID: $221$ Customer Name: Bob Hoarder Staff ID: $12$ Staff Name: Suzy Sellalot Line # Description $1234$ Gold watch Television PlayStation $2$ Bicycle Start Price $$100\mathrm{.}00$ $$150\mathrm{.}00$ $$80\mathrm{.}00$ $$65\mathrm{.}00$ Low Price $$80\mathrm{.}00$ $$120\mathrm{.}00$ $$50\mathrm{.}00$ $$45\mathrm{.}00$ Category Code $1264$ Category Description Jewelry Electronics Games Recreation Category Cost $$2\mathrm{.}00$ $$5\mathrm{.}00$ $$3\mathrm{.}00$ $$1\mathrm{.}00$ Sub Total: $$11\mathrm{.}00$ Rewards Discount: $$1\mathrm{.}10$ GST: $$0\mathrm{.}50$ Total: $$10\mathrm{.}40.$ A Consignment agreement is the information that Stuff B Gone collects from the customer to be able to sell their items for them. While the customer will receive the full selling price of their items, they are charged by Stuff B Gone for their services. The amount that Stuff B Gone charges for selling the customers' items for them depends on the category the item is in$.$ For example, if the category cost for an item is $$2\mathrm{.}00$ then the charge will be $$2\mathrm{.}00$ to sell that item for the customer. Examples of Categories are electronics, jewellery, etc. Line # identifies each item on a particular consignment.Staff Training View $(6$ marks$)$ Staff ID: $12$ Staff Name: Suzy Sellalot Type ID: $2$ Type Name: Sales Training ID $432443$ Description Sales $101$ Accounting Start Date Jan $202022$ March $42022$ End Date Jan $232022$ March $62022$ Pass$/$Fail Pass Pass $...$ Staff can take many different training courses. Many staff can take the same training course. The same training can be offered many different times. Each time it is offered it is given a new Training ID$.$ Each Staff is a certain type. These could include Sales, Promotion, etc...Customer Rewards View $(5$ marks$)$ Customer ID: $221$ Customer Name: Bob Hoarder Address: $97-11212$ Range Road $252$ Sherwood Park, AB $1811$J$2$ Email: BobHoarder Rox@hotmail.com Phone: $780555-1111$ Reward Code: $1$ Reward Description: Preferred Customer Discount Percentage: $10\%$ Customer Type ID: $1$ Customer Type Description: Individual $.$ Sometimes customers are enrolled into a reward program. If they are in a rewards program, they receive a discount on their consignment agreements. A customer is only of one type $($individual$,$ business, charity, etc...$)$ Merged ERD: $(2$ marks$)$ Create a merged ERD of your final database design for Stuff B Gone. $.$ Lab Submission will include the following: An electronic copy of your Lab $($not compressed$)$ will be submitted to Moodle A $3$NF solution for each view including ALL the attributes and entities as they appear in the initial table, $1$NF$,2$NF$,$ and $3$NF$.$ An ERD for each $3$NF solution of each view and an ERD of the merged solution $(4$ ERDs total$)$ created with an ERD modeling tool approved by your instructor $($Excel$,$ Visio, Word, Lucidchart, etc.$)..$