Question

Paragraph Styles DATABASE Write the SQL code to create the table Branch .Remember to specify the primary and foreign keys. ae-?.tl N. @??@? 5 3

Answer 1

I dont know whether you want to create a table named 'branch' or you want to get the sql statements for a table with branch. I am just guiding you to create a table named 'branch'. If this is not your requested answer, comment me.

Assume that a person is having some bank account in some branch. Primary key is the one using which we can exactly identify the records from the tables.

A branch has its own ID,name and its city name. As the question is to create a table 'branch', BranchID is the suitable primary key because no branch will have same ID and using which we can differentiate branches in different cities.

I provided the sql code to create a table named 'branch' with its primary key below:  

The following is the parent table since it contains primary key.

CREATE TABLE Branch (

BranchID     INT IDENTITY ( 1, 1 ) UNIQUE,

     BranchName   CHAR(32) NOT NULL UNIQUE,

     BranchCity   CHAR(32) NOT NULL,

PRIMARY KEY ( BranchID ),

  );

Like the above table, Let create another table named 'account' in which we can use the BranchID(primary key of the above table) as a reference here. The following is known as child table since it refers to the primary key of other table.

CREATE TABLE ACCOUNT(

     AccountID     INT IDENTITY ( 1, 1 ) UNIQUE,

     BranchID      INT NOT NULL,

     AccountNumber CHAR(20) NOT NULL UNIQUE,

     AccountType   CHAR(12) NOT NULL CONSTRAINT ATC CHECK (AccountType IN ('C','S')),

     PRIMARY KEY ( AccountID ), // This is the primary key of this table 'account'. Using AccountID we can easily acquire the account holder's details because no user will have same ID//

    FOREIGN KEY ( BranchID ) REFERENCES Branch(BranchID) // this actually links the above table with it//

);

You can also add creating tables like customer, loan account, savings account, transactions, depositer, borrower, etc. as you wish. Try and practice creating, inserting, deleting, updating and querying tables in you are a starter.