It203 Homework 3

1.What is an associative confuse? A new turn off created to instrument a umpteen-to-many relationship. It literally associates records between its two pargonnt panels. 2. narrow hotshot-to-many relationship. A row in unity parry is matched to denary rows in the min table, and a row in the second table is matched back to one row in the rate 1 table. 3.How is a one-to-many relationship copy in an ER plot? Modeling a one-to-many relationship is easy, just take the one table (lets call it member) and connect it to the many table (lets call it visits. unity member put forward have ten-fold visits.) You force need to use a crows feet connector to pertain the many relationship. 4.Define many-to-many relationship. Rows in one table are associated with many rows in the second table, and a row in the second table is associated with many rows in the first table. 5.How is a many-to-many relationship modeled in an ER diagram?

A many-to-many relationship is a bit trickier to model, lets say we have threesome tables: Customer, Order and Product. One customer can have sevenfold orders, and there can be multiple products in each(prenominal) order. To solve this problem we gusset an associative table which connects records between tables. 6.Define cardinality. The technical term utilise to describe the number of records in the relationship. 7.What is data type? The contour of information that whitethorn be stored in that attribute.If you want to arse around a mount essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: ! write my essay