QUESTION 7 The Queen Anne Curiosity Shop wants to track each...

QUESTION 7 The Queen Anne Curiosity Shop wants to track each vendor that provides many items to the store available for purchase. The following design is excellent and meets all the rules of relational database design. The design below properly defines the themes present, properly defines the appropriate primary keys, and properly meets the rules of referential integrity by defining appropriate foreign keys. PURCHASE (Purchaseltem, PurchasePrice, PurchaseDate, Vendor, Phone) True False

Transcript

00:01 Hello students, as analyze the relationship between the diagram with respect to that as the first question is what is the degree of the relation between the customer and the order? so, the degree of the relation between the customer and the order is the binary where it is an a binary relationship where as there is a one to many relationship between them it is one to many relationship one to many relationship between them.

00:38 So, each customer can have the multiple orders, but each order is associated with the one customer.

00:44 So, for the next question what is the type of the relation between the order and the textbook class? so, the type of the relation between the order and the textbook class is also the binary it is also the binary and it appears to be an many to many relationship it appears to be an many to many relationship relationship whereas, whereas in this each order can contain the multiple textbooks and each textbook can be the part of the multiple orders.

01:23 So, this type of the relationship is usually implemented using an intermediate junction table which is not in the diagram shown.

01:32 So, as the third is to which kind of the model is represented by the relation given in the diagram.

01:40 So, the relation diagram represents the er model it represents the entity relationship model entity relationship model model that is known to be an er er model.

02:04 So, which is used in a database design.

02:08 So, er model is commonly used to represent the entities such as the customer, order, textbook, author, publisher and the relationship in the database.

02:17 As the next question is what rules are applicable to the bind to the primary key field.

02:24 So, the primary key field must be unique it should not be an a not null.

02:29 So, primary key primary key must be it must be an a unique key and also it should not be an null not null.

02:43 So, each table contains a primary key which uniquely identifies each record in the table...

Question

Please give Ace some feedback