Assignment Detail


Relationships in the database description

    Assignment Instructions

    Assignment Help >> Business Management


    Which statement below is NOT true of the one-to-many relationships in the database description below?


    Image Description: Three tables are pictured: Table 1: Order details with primary keys of OrderID and ProductID and fields: UnitPrice, Quantity, and Discount. Table 2: Orders with an OrderID primary key and fields of CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, and ShipCountry. Table 3: Customer has a primary key of CustomerID, Fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, and Fax. There is a relationship labeled with the infinity symbol attached to the OrderDetails (Table 1) and also attached with a number 1 to the orders table (Table 2). There is also a relationship with the infinity symbol beginning at orders table (Table 2) and connected to the customers table (Table 2) using a 1.

    • It is the least used type of relationship.
    • OrderID is a unique identification number that would be used in the orders table and order details table.
    • Each record in the orders table may match one, more than one, or no records in the order details table.
    • Each record in an orders table matches only one record in the customers table.
    Need fresh solution to this Assignment without plagiarism?? Get Quote Now

    Expert Answer

    Asked by: Anonymous
    Plagiarism Checked
    Answer Rating:

    Plagiarism free Answer files are strictly restricted for download to the student who originally posted this question.

    Related Assignments

    Our customer support team is here to answer your questions. You can send Assignments directly to support team.
    👋 Hi, how can I help?