Shared by 
Unlock all 2 pages
Get it free by sharing your own notes, buy just this one, or become a member and unlock documents with your plan.
How to unlock this document
Choose the way that suits you. Each one gives you all 2 pages to read online and the PDF to download.
Share your notes, unlock for free
2 free unlocks for every 5 approved uploads
- Upload your own lecture notes, assignments, essays or past papers
- PDF, Word, PowerPoint and Excel files all work, and you can send many at once
- We check each upload; you get a notification when it is approved
- Spend a free unlock on this document or any other, and keep it for good
- Shared under your public username, never your email
Then upload your notes from your profile.
Buy this document
$2 one-time payment
- All 2 pages of this document, yours to keep
- Download the PDF and read it any time, also offline
- No subscription and nothing to cancel
- Find it again any time under My Profile → Library
You log in or create a free account first, then pay securely.
Become a member
Unlock documents from the whole library, which keeps growing
- Choose any documents you like, up to your plan’s unlocks
- Documents you unlock stay yours, even if you cancel later
- Your unlocks start again with every renewal
- Secure checkout by Dodo Payments
You log in or create a free account first, then pay securely.
Compare the plansAlready a member, or bought this before? Log in to open it
About this document
- Pages
- 2 pages
- Price
- $2 one-time, yours to keep
- Membership
- Included in every plan
- Format
- Subject
- Database Management, Information Systems
- Module
- Assignment 3
This assignment asks you to create an entity relationship diagram (ERD) for a cafe database. It covers the tables and fields needed for customers, orders, and inventory. It is Assignment 3.
What's inside
- Broadway Cafe database
- Entity relationship diagram (ERD)
- Customer database fields
- Orders table fields
- Inventory table fields
- Primary and foreign keys
Who it is for: Students doing this assignment. (Undergraduate)
Share with classmates: WhatsApp Telegram X LinkedIn Facebook
Summary
A Broadway Cafe database is the focus. Students learn how to create an entity relationship diagram (ERD) for a cafe's database. They practice identifying tables and fields needed for a cafe's database.
Tables for a Cafe
A cafe's database needs tables for customers, orders and inventory. Students think about other tables that a cafe might need. They decide what fields each table should have.
Customer Database Fields
The customer database needs fields for names, addresses, customer ID and customer status. Students think about other fields that might be useful.
Creating the ERD
Students create an ERD for the cafe's database. They label primary keys and foreign keys. They show how the tables relate to each other.
Submitting the Work
Students create their ERD in Word, Excel or PPT. They upload their finished ERD and submit it.
Key terms
- Entity Relationship Diagram
- A diagram that shows how tables in a database relate.
- Primary keys
- Fields that uniquely identify each record in a table.
- Foreign keys
- Fields that link records in one table to records in another.
- Customer status
- A field that shows whether a customer is active, inactive or preferred.
- MS Access
- A software tool used to create databases and ERDs.
Questions this document helps with
- What tables does a cafe's database need?
- What fields should each table have?
- How do you show relationships in an ERD?
Summary written with AI from the document's text.
Ask the AI Teacher
Ask any question about this document or your course, and get a clear explanation.
Log in to ask Create a free account
Free accounts can ask 5 questions a day.