Question

Suppose you have a table called.
(1) BILLING SYSTEM
Table :- BILLING SYSTEM
→ Cust ID
→ Cust Name
Pin Code
→ Bill_date
→ Bill no.
→ Cust_Contact
No. of products/items.
Identify the required data types and primary key​

Answer 1

Answer:

The above table contains the following columns,

→ Cust ID

→ Cust Name

→ Pin Code

→ Bill_date

→ Bill no.

→ Cust_Contact

→ No. of products/items

A column should have unique identity in each row so that it is selected as the primary key. Such a case is seen in "Cust ID".

Hence, primary key must be selected to " Cust ID".

The required types are as follows,

→ Cust ID = Integer

→ Cust Name = String

→ Pin Code = Integer

→ Bill_date = Integer

→ Bill no. = Integer

→ Cust_Contact = Integer

→ No. of products/items = Integer