Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Can you draw ER Mapping this ER diagram? Catome ma amun den nere inpy pe ane Gana un My detailed attributes Foreign keys - A key which refers to primary key of same or diflerent table Foreign keys: Custamer table - id of Payment table is the foreigr key Profit table - id of Payment teble is the foreign key For M:N relationship, create separete tables by addng primary keys of paricipating tables. These keys wil . be primery as wal as forsign kays. Multivalued attributes - hevirg more than one value Custamer - Address can be a Mulivaled atribute Emcloyoe phone, address can be a Multivalued attribute e Dertved attribute - whase value is dertved from other attricute Proft amcut can bea ered attrube deperding on payment armcunt Corposite attrbules - made up of two or mare camparents Address can be a composite attribute compased of street city ctc. nama can be a compos te attriaute comaosed of frst name and last name Sample ILILI ER Dlagram Mapping Step 1 Position (is name) Employee (id. name, sumame, position) Type of collection id name) Collection (id date, quantity, type) Order (id date, quantity. price, note, stock name, current name) Order type (id. name) Stock (id, name, price, quantity) Unit (id, name) Store (id, address, telephane) Currents (id, name, address, fax, email, telephone, debl) Step 2 Has (id, id, name, sumame) (id FK refers to employee) (id FK refers to position) Take (id, id, name, sumame, stockname, note, quantity, price, current name, date) (id FK refers to employee) (id FK refers to order) Has fid, id. stock name, note, quantity, price, current name, date) (id FK refers to order) (id FK refers to order type) Make (id. d. name, sumame, date, quantity) (id FK refers to employee) (d FK refers to collection) Include (id, id, name, quantity, date) (id FK refers to collection) (id FK refers to type pf collection)

Can you draw ER Mapping this ER diagram? Catome ma amun den nere inpy pe ane Gana un My detailed attributes Foreign keys - A key which refers to primary key of same or diflerent table Foreign keys: Custamer table - id of Payment table is the foreigr key Profit table - id of Payment teble is the foreign key For M:N relationship, create separete tables by addng primary keys of paricipating tables. These keys wil . be primery as wal as forsign kays. Multivalued attributes - hevirg more than one value Custamer - Address can be a Mulivaled atribute Emcloyoe phone, address can be a Multivalued attribute e Dertved attribute - whase value is dertved from other attricute Proft amcut can bea ered attrube deperding on payment armcunt Corposite attrbules - made up of two or mare camparents Address can be a composite attribute compased of street city ctc. nama can be a compos te attriaute comaosed of frst name and last name Sample ILILI ER Dlagram Mapping Step 1 Position (is name) Employee (id. name, sumame, position) Type of collection id name) Collection (id date, quantity, type) Order (id date, quantity. price, note, stock name, current name) Order type (id. name) Stock (id, name, price, quantity) Unit (id, name) Store (id, address, telephane) Currents (id, name, address, fax, email, telephone, debl) Step 2 Has (id, id, name, sumame) (id FK refers to employee) (id FK refers to position) Take (id, id, name, sumame, stockname, note, quantity, price, current name, date) (id FK refers to employee) (id FK refers to order) Has fid, id. stock name, note, quantity, price, current name, date) (id FK refers to order) (id FK refers to order type) Make (id. d. name, sumame, date, quantity) (id FK refers to employee) (d FK refers to collection) Include (id, id, name, quantity, date) (id FK refers to collection) (id FK refers to type pf collection)

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
Computer Science Can you draw ER Mapping this ER diagram? Calomer Is phona an ta an Is anoun viden neraet inpioy (Pro ana Are Cuand u Sa My detailed attributes Foreign keys - A key which refers to primary key of same or diflerent table Foreign keys : Custamer table - id of Payment table is the foreign key Profit table - id of Payment teble is the foreign key For M:N relationship, creste separate tables by scidng primary keys of participating tables. These kes wil. be primary as wal as forsign kays. Multivalued artributes - having more thean one value Custamer - Address can be a Multivalued attribute Employee phone, address can be a Multivalued attribute Dertved attribubte - whase value is derived from other attricute Proft amount can be a derived attrute depending on payrment ameunt Composite attrbules - made up of two ar more companents Address can be a composite attribute compased of streetcity etc. name can be a composite attriaute comaosed of first name and last name Sample IIL.ILI ER Dlagram Mapping Step 1 Position (id. name) Employee (id, name, surname, position) Type of collection id name) Collection (d. date, quantity, type) Order (id. date, quantity, price, note, stock name, current name) Order type (id. name) Stock (id, name, price, quantity) Unit (id, name) Store (id, address, telephane) Currents (id, name, address, fax, email, telephone, debl) Step 2 Has (id. id, name, surname) (id FK refers to employee) (id FK refers to position) Take (id, id, name, sumame, stockname, note, quantity, price, current name, date) (id FK refers to employee) (id FK refers to order) Has fid, id. stock name, note, quantity, price, current name, date) (id FK refers to order) (id FK refers to order type) Make (d. id, name, sumeme, date, quantity) (id FK refers to employee) (d FK refers to collection) Include (id, id, name, quantity, date) (id FK refers to collection) (id FK refers to type pf collection) 10
Transcribed Image Text:Computer Science Can you draw ER Mapping this ER diagram? Calomer Is phona an ta an Is anoun viden neraet inpioy (Pro ana Are Cuand u Sa My detailed attributes Foreign keys - A key which refers to primary key of same or diflerent table Foreign keys : Custamer table - id of Payment table is the foreign key Profit table - id of Payment teble is the foreign key For M:N relationship, creste separate tables by scidng primary keys of participating tables. These kes wil. be primary as wal as forsign kays. Multivalued artributes - having more thean one value Custamer - Address can be a Multivalued attribute Employee phone, address can be a Multivalued attribute Dertved attribubte - whase value is derived from other attricute Proft amount can be a derived attrute depending on payrment ameunt Composite attrbules - made up of two ar more companents Address can be a composite attribute compased of streetcity etc. name can be a composite attriaute comaosed of first name and last name Sample IIL.ILI ER Dlagram Mapping Step 1 Position (id. name) Employee (id, name, surname, position) Type of collection id name) Collection (d. date, quantity, type) Order (id. date, quantity, price, note, stock name, current name) Order type (id. name) Stock (id, name, price, quantity) Unit (id, name) Store (id, address, telephane) Currents (id, name, address, fax, email, telephone, debl) Step 2 Has (id. id, name, surname) (id FK refers to employee) (id FK refers to position) Take (id, id, name, sumame, stockname, note, quantity, price, current name, date) (id FK refers to employee) (id FK refers to order) Has fid, id. stock name, note, quantity, price, current name, date) (id FK refers to order) (id FK refers to order type) Make (d. id, name, sumeme, date, quantity) (id FK refers to employee) (d FK refers to collection) Include (id, id, name, quantity, date) (id FK refers to collection) (id FK refers to type pf collection) 10
Expert 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