exercise 4.3.1: for your e/r diagrams of: a) exercise 4.1.1. b) exercise 4.1.3. c) exercise 4.1.6. (i) select and specify keys, and (ii) indicate appropriate referential integrity constraints.

Respuesta :

When we Convert the ER - Diagram to Relational schema tables we add Referential Integrity Constraint on Many Side when There is a Relationship cardinally 'one - Many' or 'many - many' exists.

Here, the primary key is SSN. in the customer's database, a foreign key.

"code is the Primary Key in the Bank table. Foreign key in the Accout table." Foreign key in the table "Bank Branch" A primary key for the Bank Branch table will be formed using the words "code" and "Bank Brancho."

Key forgery in the Account table.

Here Team code serves as the main key in the team table and the foreign key in the player table.

P-id is the primary key in the "players" table and the "fans" table's foreign key.

To ensure that each piece of information in a given column is unique, a primary key is employed. A column or set of columns in a relational database table known as a foreign key serves as a connection between the data in two different databases. It designates a record in the relational database table in an exclusive manner.

Learn more about Relational here:

https://brainly.com/question/17373950

#SPJ4