Question
Create an ERD diagram for the Colonial Adventures database, make sure to add the Primary and Foreign key dependencies . Use Microsoft Visio or similar
Create an ERD diagram for the Colonial Adventures database, make sure to add the Primary and Foreign key dependencies . Use Microsoft Visio or similar tool for this. CREATE A VISUAL ERD DIAGRAM PLEASE.
Figure 1-4. Sample Guide Data for Colonial Adventure Tours GUIDE GUIDE NUM LAST NAME FIRST NAME ADDRESS Abrams Boyers Devon AMOR BROJ DH01 G201 K801 K802 MRO1 RHOI SLO UGO1 Gregory Kiley Kelly Marston Rowan Stevens Unser Miles Rita Harley Zach Susan Samti Ray Hal Lori Glory CITY STATE POSTAL CODE PHONE NUM HIRE DATE 617-555-6032 6/3/2012 603-555-2134 3/4/2012 781-555-7767 1/8/2012 603-555-8765 11/4/2012 603-555-1230 4/8/2013 603-555-0003 6/10/2013 781-555-2323 9/14/2015 207-555-9009 6/2/2014 802-555-3339 9/5/2014 203-555-8534 2/2/2015 54 Quest Ave. Williamsburg MA 01096 140 Oakton Rd. Jaffrey NH 03452 25 Old Ranch Rd. Sunderland MA 01375 7 Moose Head Rd. Dummer NH 03588 943 Oakton Rd. Jaffrey NH 03452 9. Congaree Ave. Fraconia NH 03580 24 Shenandoah Rd. Springfield MA 01101 12 Heather Rad Mount Desert ME 04660 15 Riverton Rd. Coventry VT 342 Pineview St. Danbury CT 05825 06810
Step by Step Solution
3.34 Rating (163 Votes )
There are 3 Steps involved in it
Step: 1
First Lets Define The EntitiesAttributes and Relations Entities Customer Trip Destination Guide Booking TripGuides Attributes Customer customerid Primary Key customernum lastname firstname address cit...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Systems analysis and design
Authors: kenneth e. kendall, julie e. kendall
8th Edition
135094909, 013608916X, 9780135094907, 978-0136089162
