Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a relational database schema in 3NF, specifying table names, attributes, Primary and Foreign Keys Spring Breaks 'R' Us (SBRU) is an online travel service

Develop a relational database schema in 3NF, specifying table names, attributes, Primary and Foreign Keys Spring Breaks 'R' Us (SBRU) is an online travel service that books spring break trips to resorts for college students. The head office comprises 6 members of staff, all of whom are involved in the booking process; the manager and assistant manager in his absence, are also responsible for regular administrative duties such as payroll, accounts etc. Students have booked spring break trips for decades, but changes in technology have transformed the travel business in recent years. SBRU moved away from having campus reps with posted fliers and moved to the Web early on. The basic idea is to get a group of students to book a room at a resort for one of the traditional spring break weeks. SBRU contracts with dozens of resorts in key spring break destinations in Florida, Texas, the Caribbean, and Mexico

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions

Question

7. Where Do We Begin?

Answered: 1 week ago