Please follow the instructions ...

Student_Id
                Student_Name
                Title of Assignment
Business rules for Above Case study
Following is list of tables
Table name: Employee where Employee_id is primary key
    Name of field
    Data type
    Primary/foreign key
    Employee_id
    Number
    Primary key
    Employee_fname
    Text
    
    Employee_lname
    Text
    
    Employee_address
    Text
    
    Employee_city
    Text
    
    Employee_state
    Text
    
    Employee_zipcode
    Text
    
    Employee_contactno
    Text
    
    Employee_type
    Text
    
    Department_id
    number
    
Table name: Department where Department_id is primary key
    Name of field
    Data type
    Primary/foreign key
    Department_id
    Number
    Primary...