Assuming that one item can only be stored in one location (that is, one room in one building), starting with the dependency diagram drawn for Question 2.1, create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and/or attributes as necessary. The dependency diagram will be created using the online drawing tools I mentioned in the syllabus or any other tools you prefer.

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF.   FIGURE P6.2 PRESENTATION ERD FOR PROBLEM 2

1. Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool. 2. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes.   Schema 3    You have been hired by the Snowbird ski mountain resort to build a database for their data. The resort has ski mountain peaks, chair lifts, trails, stores and restaurants. For each mountain peak, you track the name, the elevation and its latitude and longitude. Each peak name is unique. The names of the mountain peaks are: Mount Superior, Mount Baldy, Twin Peaks and Hidden Peak. For each chair lift, you track a unique name, the vertical rise, the travel time, the number of people per chair (ranging from 2 to 4) , and its closing time. For each trail, you track its unique name, its elevation, its length, and the typical time it takes to complete. Each ski trail is classified by its level of…

You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…

You may assume the followings:    • Each material item has one or more vendor. Each vendor may supply one or more.  items or may not supply any items. • The unit price for a material item may vary from one vendor to another. • The terms for a supplier are the same for all material items ordered from that supplier.     Please answer the following questions: 1. Draw a dependency diagram to show the functional dependencies in the relation.   2. Decompose the relation into a set of 1NF, 2NF & 3NF relations with each normal form dependency diagram

Why do you need to design a dependency diagram, and what are some of its applications?

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.2 into a dependency diagram that is in at least 3NF.

When mapping generalisations and specialisations in enhanced entity relationship diagrams, which solution will deliver the least redundancy and allow representation of the most specialisation types. Select one: a. Multiple relations representing subclass entities only. b. A single relation containing a type attribute. c. Multiple relations representing both superclass and subclass entities. d. A single relation with multiple boolean type attributes.

A business wants to design a database for its daily operations. The business rules are given below. Create an ER diagram with necessary attributes that reflect the given business rules. You might use any style for the ER diagram. If it is applicable, include the cardinality in the diagram and use the diagram to identify weak entities and weak relationships. Business Rules: • A store may place many orders. • An order must be placed by a store • An order contains at least one order line. • Each order line is contained in one and only one order. • Each order line has a specific product written in it. • A product may be written in many orders. • A store may employ many employees • Each employee is employed by one (and only one) store. • An employee may have one or more dependents. • A dependent must be related to an employee.

Using the descriptions of the attributes given in the figure, convert the ERD shown in Figure P6.1 into a dependency diagram that is in at least 3NF.