Northwind DatabaseGiven the following schema:REGION ( RegionID, RDescription)TERRITORIES ( TerritorylD, TDescription, RegionID@)CATEGORIESCategoryIDCategoryName, Description)SUPPLIERS ( SupplierlD, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone)SUPPLIERCUSTOMERS ( CustomerID.SHIPPERSPRODUCTS ( ProductID, ProductNamePhone)SupplierID@, CategorylD@, QuantityPerUnit, UnitPrice, UnitslnStock, UnitsOnOrder, ReorderLevel, Discontinued)FRODUCTEMPLOYEES (EmployeelD, LastName, FirstName, Title, BirthDate, HireDate, Address, City, RegionID@, PostalCode, Country, HomePhone, Extension, ReportsTo@)EMPLOYEETERRITORIES (EmployeelD@. TerritoryID@)ORDERS ( OrderlID, CustomerlD@, EmployeelD@, TeritoryID@. OrderDate, RequiredDate, ShippedDate, ShipVia@, Freight, ShipName, ShipAddress, ShipCity. ShipRegion, ShipPostalCode, ShipCountry)ORDERDETAILS ( OrderlD@. ProductID@. UnitPrice, Quantity, Discount)Note that an underlined attribute means it is a primary key while an attribute@ like this means it is a foreign key.Create the Crow's Foot ERD corresponding to the schema above.Make sure to capture all attributes, PKs, FKs, and relationships.

Entities are represented as a rectangle in crow's foot notation, with their name at the top. The…

Answered: Create the Crow's Foot ERD…

Engineering

Computer Engineering

Create the Crow's Foot ERD corresponding to the schema above.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

QUESTION 4 For the following collection of entities, give the assumptions concerning the relationship between entities. ORDER (order#, ordDate, cust#, cName ) ORDER_PART ( order#, part#, quantity ) PART ( part#, description, price )
What is a Derived Attribute and how does it work?
I need help building an ERD in Crow's Foot notation with the following (If possible show me any many-many and optional/mandatory relationship) :
The table structure shown in Table P6.6 contains many unsatisfactory components and characteristics. a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies.b. Draw the dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.)c. Draw the relational diagram.d. Draw the Crow's Foot ERD.
Question 3 Normalize table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the component(s) that is/are removed from each Normal Form. Besides that, INF must be divided into repeating and non-repeating group relations. a) PatientID PatientName BloodID BloodType ExamDate DiseaselD DiseaseDesc HospitallD HospitalName 08/01/2020 D5001 08/01/2020 D3222 |11/11/2020 D5001 |11/11/2020 D7788 15/11/2020 D5001 12/12/2020 D3222 12/12/2020 D5001 Alice Hospital KL Hospital KL Hospital PJ Hospital SB Hospital SB Hospital KL Hospital PJ P7010 B001 B001 B001 A+ COVID-19 Н223 P7010 Alice A+ Diabetes H223 Alice Thomas P7010 A+ COVID-19 H881 P8888 B008 O- SARS H666 Penny Penny Julie P3000 B009 AB+ COVID-19 H666 P3000 B009 AB+ Diabetes H223 P4455 B008 0- COVID-19 H881 Table 1: Details of…
Use Figure 2 provided in the handout in order to answer this question. Using any software of choice (e.g. Word, PPT, Online Visual Paradigm) create a set of dependency diagrams that meet 3NF requirements. Make sure you rename attributes to meet naming conventions and create any new entities and/or attributes as you deem necessary. If you use a Microsoft Office program you can upload the file, if you use Visual Paradigm submit a screen shot of your dependency diagram in a MS Word file.
List the pros and cons of the star schema over the snowflake form. Which is odder?
Kindly go through this. The database development starts with the requirements analysis. There are many sources for gathering requirements. One of the important sources for requirements is “user interview”. During these interviews, users are asked about what kind of a system they need. Then requirements gathered from the interviews are transformed into a data model. Assume that a database designer made an interview and created an E-R diagram as above. Write a scenario that the user described requirements as in the Library Management System case study in Chapter 3.3 of Sharma et al. (2010, p. 77) during the interview - 3.3 A case study involving a Library Management System - This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms:"The system will manage author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The…
- The restaurant has two waiters (named John and Ali) taking order and collect payment from the customer. The customer can choose to pay using cash, Touch’n Go or credit card. The customer detail in the receipt is optional. Base on the given information above, draw a complete Entity-Relationship Diagram (ERD) with Crow’s Foot notation. Write all appropriate attributes, connectivity and cardinalities in the ERD.
Write the proper sequence of activities for the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions.)
Assume that an attribute comprising a primary key is also a candidate key. What would be your response?
Translate the E-R diagram on page 1 (diagram) to database schema using MySQL Workbench (export as png or pdf). You can ignore the cardinalities on the ternary (Grant) relationship. Interpret the database schema on slide 4. Draw the E-R diagram underlying this schema. No need to draw the attributes.