5.6 Designing a Database A primary key must be selected for each table in a relational database. This key is a unique identifier for each record in the table. A foreign key is a field in one table that connects to the primary key data in the original table. STUDENT StudentID StudentName StudentMajor StudentEmail GRADE COURSE CLASSROOM StudentID -CourseID ClassroomID CourseID Course Title Classroom Type Grade CourseCapacity ClassroomID ClassroomCapacity Instructions This assignment helps you to understand basics of databases. 1. Using a Cake Order Database as an example, create three tables: Order, Cake, Customer. Identify 5 or more important fields for each of the tables. Identify the primary keys for the tables. 2. Draw a database design diagram like the diagram on Page 108 ("School Database Design Relationships") of the textbook, showing the tables (with fields) and relationships among the tables. 3. Using this example, explain benefits of databases for data management as opposed to Excel files. Significance (30%) Analytical and thinking Skills (40%) Written Presentation (30%) Learning Outcomes of Assignment The assignment adds significant values to your understanding of information systems ⚫ The assignment provides excellent materials ⚫ The assignment demonstrates your understanding of the subject ⚫ The assignment demonstrates your active learning ability ⚫ The assignment is well edited and is organized into clear sections with "topic sentences" that highlight your major points ⚫ The assignment provides complete references and citations (e.g., URL of information sources) Performance Poor Excellent 0.100
5.6 Designing a Database A primary key must be selected for each table in a relational database. This key is a unique identifier for each record in the table. A foreign key is a field in one table that connects to the primary key data in the original table. STUDENT StudentID StudentName StudentMajor StudentEmail GRADE COURSE CLASSROOM StudentID -CourseID ClassroomID CourseID Course Title Classroom Type Grade CourseCapacity ClassroomID ClassroomCapacity Instructions This assignment helps you to understand basics of databases. 1. Using a Cake Order Database as an example, create three tables: Order, Cake, Customer. Identify 5 or more important fields for each of the tables. Identify the primary keys for the tables. 2. Draw a database design diagram like the diagram on Page 108 ("School Database Design Relationships") of the textbook, showing the tables (with fields) and relationships among the tables. 3. Using this example, explain benefits of databases for data management as opposed to Excel files. Significance (30%) Analytical and thinking Skills (40%) Written Presentation (30%) Learning Outcomes of Assignment The assignment adds significant values to your understanding of information systems ⚫ The assignment provides excellent materials ⚫ The assignment demonstrates your understanding of the subject ⚫ The assignment demonstrates your active learning ability ⚫ The assignment is well edited and is organized into clear sections with "topic sentences" that highlight your major points ⚫ The assignment provides complete references and citations (e.g., URL of information sources) Performance Poor Excellent 0.100
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...
Related questions
Question
Follow the question pattern that I gave you and do it accordingly and please dont plagarise or use any AI.Thank you
Transcribed Image Text:5.6 Designing a Database
A primary key must be selected for each table in a relational database.
This key is a unique identifier for each record in the table.
A foreign key is a field in one table that connects to the primary key data
in the original table.
STUDENT
StudentID
StudentName
StudentMajor
StudentEmail
GRADE
COURSE
CLASSROOM
StudentID
-CourseID
ClassroomID
CourseID
Course Title
Classroom Type
Grade
CourseCapacity
ClassroomID
ClassroomCapacity
Transcribed Image Text:Instructions
This assignment helps you to understand basics of databases.
1. Using a Cake Order Database as an example, create three tables: Order, Cake, Customer. Identify 5 or
more important fields for each of the tables. Identify the primary keys for the tables.
2. Draw a database design diagram like the diagram on Page 108 ("School Database Design Relationships")
of the textbook, showing the tables (with fields) and relationships among the tables.
3. Using this example, explain benefits of databases for data management as opposed to Excel files.
Significance
(30%)
Analytical and
thinking Skills
(40%)
Written
Presentation
(30%)
Learning Outcomes of Assignment
The assignment adds significant
values to your understanding of
information systems
⚫ The assignment provides excellent
materials
⚫ The assignment demonstrates your
understanding of the subject
⚫ The assignment demonstrates your
active learning ability
⚫ The assignment is well edited and is
organized into clear sections with
"topic sentences" that highlight your
major points
⚫ The assignment provides complete
references and citations (e.g., URL
of information sources)
Performance
Poor Excellent
0.100
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY