roject name: job management system   i want code

A+ Guide To It Technical Support
10th Edition
ISBN:9780357108291
Author:ANDREWS, Jean.
Publisher:ANDREWS, Jean.
Chapter18: Macos, Linux, And Scripting
Section: Chapter Questions
Problem 9TC
icon
Related questions
Question

Project name: job management system

 

i want code 

job
Pid: INTEGER
client
O name: VARCHAR(30)
O description: VARCHAR(50)
O rate: INTEGER
O4 Pemployee_id: INTEGER
Pid: INTEGER
O name: VARBINARY(30)
O phone: NUMERIC(30,0)
invoice
O4P client_id: INTEGER
Pinvoice_no: NUMERIC(0,0)
Pmanger_id: INTEGER
O date: DATE
client_id: INTEGER
O rate: INTEGER
O column4: INTEGER
employee
manger
Pid: INTEGER
Pid: INTEGER
O name: VARCHAR(30)
O phone: NUMERIC(30,0)
O adress: VARCHAR(30)
O phone: NUMERIC(30,0)
O name: VARCHAR(30)
Transcribed Image Text:job Pid: INTEGER client O name: VARCHAR(30) O description: VARCHAR(50) O rate: INTEGER O4 Pemployee_id: INTEGER Pid: INTEGER O name: VARBINARY(30) O phone: NUMERIC(30,0) invoice O4P client_id: INTEGER Pinvoice_no: NUMERIC(0,0) Pmanger_id: INTEGER O date: DATE client_id: INTEGER O rate: INTEGER O column4: INTEGER employee manger Pid: INTEGER Pid: INTEGER O name: VARCHAR(30) O phone: NUMERIC(30,0) O adress: VARCHAR(30) O phone: NUMERIC(30,0) O name: VARCHAR(30)
Erd diagram
LID
Name
C on
Ju
Clent
phone
phone
mploye
adre
Cansign
CetD
ice
manager
Nae
data
Involce no
phone
Schema diagram
client
C ID
Name
Phone
PK
job
J ID
Name
description
rate
E_ID
CID
M_ID
PK
employee
E ID
Name
adress
Phone
invoice
PK
invoice_no
data
C_ID
column4
rate
manger
PK
M_ID
Phone
Name
Transcribed Image Text:Erd diagram LID Name C on Ju Clent phone phone mploye adre Cansign CetD ice manager Nae data Involce no phone Schema diagram client C ID Name Phone PK job J ID Name description rate E_ID CID M_ID PK employee E ID Name adress Phone invoice PK invoice_no data C_ID column4 rate manger PK M_ID Phone Name
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Project Roles
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A+ Guide To It Technical Support
A+ Guide To It Technical Support
Computer Science
ISBN:
9780357108291
Author:
ANDREWS, Jean.
Publisher:
Cengage,