Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
REQUIREMENTS TABLE: Field Name Data type Field size Constraints Content / Description REQUESTS TABLE: Hem JD Primary Key Store tem D Int Hem Name Varchar 50 Store item name Not nul Unit Varchar 20 Not nul Store item unit Remarks Varchar 100 Store item remarks In Stock Int Not nul Store the number of items in stock Content/ Description Ficld Name Data type Field size Constraints Requesto Int Primary Key Store request ID FEEDBACK TABLE: Hems_requested Varchar 300 Store items requested Not nul Staft email Varchar 50 Foreign Key Store staff emoil Field Name Data type Field size Constraints Content / Description Date Date Not nul Store request date FRJD Int Primory Key Store feedback ID Staft-Name Varchar 50 Not nul Sore staff name Staff e-mail Varchar 50 Foreign Key Store statt e-mail FB_date Date Not null Store feedback date Feedbock Varchar 1000 Not nul Store staff feedback

REQUIREMENTS TABLE: Field Name Data type Field size Constraints Content / Description REQUESTS TABLE: Hem JD Primary Key Store tem D Int Hem Name Varchar 50 Store item name Not nul Unit Varchar 20 Not nul Store item unit Remarks Varchar 100 Store item remarks In Stock Int Not nul Store the number of items in stock Content/ Description Ficld Name Data type Field size Constraints Requesto Int Primary Key Store request ID FEEDBACK TABLE: Hems_requested Varchar 300 Store items requested Not nul Staft email Varchar 50 Foreign Key Store staff emoil Field Name Data type Field size Constraints Content / Description Date Date Not nul Store request date FRJD Int Primory Key Store feedback ID Staft-Name Varchar 50 Not nul Sore staff name Staff e-mail Varchar 50 Foreign Key Store statt e-mail FB_date Date Not null Store feedback date Feedbock Varchar 1000 Not nul Store staff feedback

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

drow ER deigram for this table

REQUIREMENTS TABLE: Field Name Data type Constraints Content / Description Field size REQUESTS TABLE: Item ID Primary Key Store item ID Int 5 tem_Name Varchar 50 Not null Store item name Unit Varchar 20 Not null Store item unit Remarks Varchar 100 Store item remarks In_Stock int Not null Store the number of items in Content / Description Field Name Data type Field size Constraints stock RequestID Int 5 Primary Key Store request ID FEEDBACK ТАBLE: Items_requested Varchar 300 Not null Store Items requested Staff email. Varchar 50 Foreign Key Store staff email Field Name Data type Field size Constraints Content / Description Date Date Not null Store request date FB_ID Int Primary Key Store feedback ID 5 Staff-Name Varchar 50 Not null Sore staff name Staff_e-mail Varchar 50 Foreign Key Store staff e-mail FB date Date Not null Store feedback date Feedback Varchar 1000 Not null Store staff feedback
Transcribed Image Text:REQUIREMENTS TABLE: Field Name Data type Constraints Content / Description Field size REQUESTS TABLE: Item ID Primary Key Store item ID Int 5 tem_Name Varchar 50 Not null Store item name Unit Varchar 20 Not null Store item unit Remarks Varchar 100 Store item remarks In_Stock int Not null Store the number of items in Content / Description Field Name Data type Field size Constraints stock RequestID Int 5 Primary Key Store request ID FEEDBACK ТАBLE: Items_requested Varchar 300 Not null Store Items requested Staff email. Varchar 50 Foreign Key Store staff email Field Name Data type Field size Constraints Content / Description Date Date Not null Store request date FB_ID Int Primary Key Store feedback ID 5 Staff-Name Varchar 50 Not null Sore staff name Staff_e-mail Varchar 50 Foreign Key Store staff e-mail FB date Date Not null Store feedback date Feedback Varchar 1000 Not null Store staff feedback
ADMINS TABLE: STAFF TABLE: Data type Field size Constraints Content / Description Field Name Field Name Data type Field size Content / Description Constraints Admin_ID Primary Key Store admin ID Int 5 E-mail Varchar 50 Primary Key Store staff e-mail First_Name Not null Store admin first name Varchar 50 First_Name Varchar 50 Not null Store staff first name Last Name Varchar Store admin last name 50 Not null Last_Name Varchar 50 Not null Store staff last name Username Varchar 15 Not null Store admin username Username Varchar 15 Not null Store staff username Password 15 Password Varchar 15 Not null Store staff password Varchar Not null Store admin password Office Varchar 50 Not null Store staff office E-mail Varchar 100 Not nll Store admin e-mail Gender 1 Store staff gender Char Not null Store admin gender Store admin phone number Gender Char 1 Not null Phone_numbe int 8 Not null Phone_numbe int Store staff phone number 8 Not null Department Not null Store admin department Varchar 50 Department Varchar 50 Not null Store staff department name name
Transcribed Image Text:ADMINS TABLE: STAFF TABLE: Data type Field size Constraints Content / Description Field Name Field Name Data type Field size Content / Description Constraints Admin_ID Primary Key Store admin ID Int 5 E-mail Varchar 50 Primary Key Store staff e-mail First_Name Not null Store admin first name Varchar 50 First_Name Varchar 50 Not null Store staff first name Last Name Varchar Store admin last name 50 Not null Last_Name Varchar 50 Not null Store staff last name Username Varchar 15 Not null Store admin username Username Varchar 15 Not null Store staff username Password 15 Password Varchar 15 Not null Store staff password Varchar Not null Store admin password Office Varchar 50 Not null Store staff office E-mail Varchar 100 Not nll Store admin e-mail Gender 1 Store staff gender Char Not null Store admin gender Store admin phone number Gender Char 1 Not null Phone_numbe int 8 Not null Phone_numbe int Store staff phone number 8 Not null Department Not null Store admin department Varchar 50 Department Varchar 50 Not null Store staff department name name
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS