Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Please follow the instructions ...

1 answer below »
Please follow the instructions ...
qfile_636807314980106152_123773_1.PNG qfile_636807314980106152_123773_2.PNG
Answered Same Day Dec 18, 2020 ITC556 Charles Sturt University

Solution

Ankit answered on Dec 19 2020
158 Votes
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
    Numbe
    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
    numbe
    
Table name: Department where Department_id is primary key
    Name of field
    Data type
    Primary/foreign key
    Department_id
    Numbe
    Primary...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File