Please follow the instructions ...

1 answer below »
Answered Same DayDec 18, 2020ITC556Charles Sturt University

Answer To: Please follow the instructions ...

Ankit answered on Dec 19 2020
146 Votes
Student_Id
                Student_Name
                Title of Assignment
Business rules for Above Case study
Followin
g 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here