Find Jobs
Hire Freelancers

Crow's Foot ERD Diagrams

$20-45 USD

Færdiggjort
Slået op over 8 år siden

$20-45 USD

Betales ved levering
Deadline is 24 hours. max price is $45 Part 1: Sunset Zoo The Sunset Zoo currently tracks its membership using a spreadsheet, and wants to upgrade to using a relational database. You have been tasked with this conversion, and need to convert this flat field design into a relational database design. Sunset Zoo has given you its current spreadsheet design, which contains the following fields (columns). • Member ID • Member Name • Member Phone • Member Email • Membership Level Name • Membership Level Description • Membership Price • Price w/tax • Paid Until Date • Member Since • Event 1 Name • Event 1 Description • Event 1 Attended • Event 2 Name • Event 2 Description • Event 2 Attended • Event 3 Name • Event 3 Description • Event 3 Attended Sunset Zoo has also given you the following business rules, which are incomplete and are not all necessarily structural. • Members purchase a yearly membership. • The memberships are one of three levels: Basic, Zoo Friend, Zoo Star. • Memberships are generally paid once a year. • Three special events are offered each year, and attendance is tracked for each member. 1. To get started, create a complete list of business rules that you will use as a basis for your logical diagram. Your list of business rules should specify all entities, relationships, optionality constraints, and plurality constraints, and must make provision for the data and business rules given to you by the Sunset Zoo. There are many solutions that will correctly make provision for the given data and business rules. 2. Now create a logical entity-relationship diagram (ERD) that illustrates the relational database design described by the business rules in #1. All entities should be normalized to BCNF. Recall that logical ERDs contain SQL-based constraints on the attributes, including primary and foreign key constraints. Part 2: Sports Fans The following incomplete list of business rules describe the relationships between some of the different types of sports fans in New England. 1. Baseball Fans can be Red Sox fans, Yankee Fans, both, or neither. 2. All Baseball Fans are People, but not all People are Baseball Fans. 3. Some Red Sox fans are also Celtics Fans. 4. Celtics Fans are People, but not all people are Celtics Fans. 5. Both Red Sox fans and Celtics Fans are Sports Fans. 6. Sports Fans are People, but not all People are Sports Fans. This is may seem fairly simple, and intuitively obvious to anyone living in Boston, but there are some subtleties nonetheless. "Red Sox" and "Yankees" are names of two rival baseball teams in Boston and New York, and "Celtics" is the name of the basketball team in Boston. I’ve helped you a bit by capitalizing the words for entities. 1. Create a complete list of business rules that are consistent with the incomplete list given above. This list should make provision for all entities and relationships given in the above list, and there are many solutions that do so. 2. Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules in #1. The diagram should include the primary key of each table in order to demonstrate correct implementation of specialization-generalization. While EERDs may well contain other attributes, in this assignment you need not include them because they are not described in the business rules. You should use legal database identifiers such as Yankees_Fan or Sports_Fan in your EERD.
Projekt-ID: 8510589

Om projektet

4 forslag
Projekt på afstand
Aktiv 9 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
Hello Friend i have expertise in database development and having vast experience of this i m doing this job since 2012 in software indusrty i can do this job easily
$45 USD på 1 dag
5,0 (2 anmeldelser)
3,1
3,1
4 freelancere byder i gennemsnit $42 USD på dette job
Brug Avatar.
Aucune proposition n'a encore été fournie.
$45 USD på 1 dag
4,0 (1 bedømmelse)
1,0
1,0
Brug Avatar.
I have a good knowledge of making an EErd . I will try to deliver your project as soon as possible. probably in one day. Is there only a EERD is required or any thing else you want send me the complete knowledge of it. what is basically required . i already read the scenario.
$40 USD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Hi there...! Our team provides full range of internet marketing services to various businesses for over 10 years. Our experience helps to define the best online strategy to serve your marketing and sales needs. We always split projects in phases and would like to offer the same approach for your company as well. We'd like to offer the following phases and activities for your project: Phase 1 - Create a basic website, establish a presence of your business in social media Phase 2 - Define a content development strategy, create valuable content and start sending newsletters Phase 3 - Enhance your sales channels with eCommerce; build customer area Phase 4 - Use online and offline advertising and multimedia; improve your search engines visibility Please take a look at our proposal and don't hesitate to contact me if you have any questions.
$37 USD på 3 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Boynton Beach, United States
5,0
8
Betalingsmetode verificeret
Medlem siden sep. 19, 2015

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.