Question

2. State the relationship and difference between a primary and foreign key?

3. List datatypes available in Numeric Datatype?

4. List datatypes available in Alphaumeric Datatype?

5. List datatypes available in Numeric Datatype?

6. List datatypes available in Data Datatype​

Answer 1

PLZ MARK AS BRAINLIEST!!!!!

2. A primary key is a unique value that identifies  a row in a table.Primary Keys are  also indexed in the database, making it faster for the database to search for a record.

foreign key identifies a column or set of columns in one (referencing) table that refers to a  column or set of columns in another (referenced) table. The “one” side of a relation is always the parent, and provides the PK attributes to be copied.

4.         Name                              data type

    LONGVARCHAR                    Memo    

       CHAR                                   Text (fix)

     VARCHAR                               Text

    VARCHAR_IGNORE  CASE      Text

 5.

Name                 Data type

BOOLEAN            Yes / No

TINYINT              Tiny Integer

SMALLINT           Small Integer

INTEGER                  Integer

BIGINT                  Big Integer  

NUMERIC              Number

DECIMAL               Decimal

REAL                         Real

FLOAT                     Float

DOUBLE Double