Use Draw.IO https://www.draw.io/ to create an ERD based on the following information:• The RDBMS would be required to support the mall’s entire information system.• After data was stored in an RDBMS, it would provide a variety of archival andinformation services to PCM.• Database design must enable a product to be categorized, subcategorized, andsearched in three ways:1. Search products by categories.2. Search products individually by name or Product ID.3. Search products by stores.• The database must support the following six entities:1. Employees2. Stores3. Product categories4. Product subcategories5. Products (generally)6. Store products (products sold at a store).Identify the following:A. Primary KeysB. Foreign KeysC. Attributes- At least 5 per entityD. 1:N relationships

The administrators of Tiny College are so pleased with your design and implementation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows:• Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s Travel Far But Slowly (TFBS) Center.• Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required,…

The following step is used to remove first node from the AVAIL list. NEW: =AVAIL AND AVAIL: =LINK[AVAIL] Select one: True False

Identify and determine when it is appropriate to utilize a 1:M and a M:M relationship in a database