Preview

CS669 Assignment2

Good Essays
Open Document
Open Document
1108 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
CS669 Assignment2
The two parts in this assignment will contribute equally to your grade and will be evaluated separately.

Part 1: Authors and Books
Review the following business rules regarding authors and books to complete this part.
An author writes one or more books.
A book is written by one or more authors.
A subject applies to at least 20 books.
A book is published in a year.
The business rules above specify all of the relevant entities; however, some business rules do not specify both sides of the relationship. You will be completing this list of business rules.

1. To get started, list the names of all entities provided in the business rules above.

2. Identify the entities that are related to each other.

3. Identify the optionality and plurality constraints on both sides of each relationship, where possible. Indicate where the provided business rules do not provide the optionality and plurality constraints.

4. Create a complete list of business rules. The new list should not add additional entities, but should specify the optionality and plurality constraints for both sides of all relationships. Make reasonable assumptions to create the list and state your assumptions. There is no provably “right” list of assumptions.

5. Create a conceptual entity-relationship diagram using Crow’s Foot notation that reflects your list of business rules. You may use Microsoft Visio Pro or another similarly capable drawing application to produce your ERD. Note that cardinalities are not required in the diagram, though relationship connectivities are required.
Part 2: Veterinary Clinic
In this part, you will be repeating the same steps in Part 1 for a more complex veterinary clinic scenario. Review the following business rules then complete the steps indicated below.
Every pet has an owner.
Owners have one or more pets.
A pet may have multiple appointments with multiple veterinarians in the clinic.
One veterinarian attends each appointment.
Each appointment results in a bill for the

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The Wiremap test is used to identify physical errors of the installation; proper pin termination at each end, shorts between any two or more wires, continuity to the remote end, split pairs, crossed pairs, reversed pairs, and any other mis-wiring. It tests four-pair data and voice cable links terminated with standard, modular, eight-position RJ45 jacks. Shielded ports test both shielded and unshielded cabling. This is essential for just about any network as telephones (voice) are also used in conjunction with data communications. This tester should be a part of every cable installation kit.…

    • 256 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    It is important to test the cables before you install them and after they are installed. Although there are many tools that are used for testing the cables in a network this paper is only going to talk about three. The first one is the multifunction cable scanner, they are available for testing both copper and fiber optic cable. One such model is the Hobbes 258898 it can test every pin of almost 20 often used cables from coax to 40 pin ribbon cables. It identifies opens, shorts and mis-wires at the pin level. With a multifunction cable tester you can perform a range of tests that you would normally need a few different testers to do. You can do wire-mapping, test for the length of the cable, test the attenuation, and you can test NEXT (near end crosstalk) for copper cables. They will also test for optical power and signal loss in fiber optic cables. A lot of the multifunction cable testers perform other more comprehensive test such as PS-NEXT, ACRF, PS-ACRF, delay…

    • 659 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    A good example of refraction of light and reflection of light is a rainbow. Sunlight enters the rain droplet at a specific angle and the rain droplet separates the white light into many different colors. This angle is a fixed measurement between your eye and the sun. What color is refracted depends upon the critical angle, which is the angle the sunlight strikes the back of the rain droplet. Red light bends the least while violet light bends the most all the other colors bend at an angle that is between the two. Each rain droplet reflects all colors at a given point and time, but only one color comes back to your eye, requiring millions of rain droplets to create a rainbow. As the rain droplets fall…

    • 395 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    CODE FOR THE ABOVE FRAGMENT addi $t6, $zero, 101 # the loop termination value add $t0, $zero, $zero # i = 0 addi $t2, $a0, 0 # ptr to current A[i] addi $t3, $a1, 0 # ptr to current B[i] loop: lw $t4, 0($t3) # load B[i] add $t4, $t4, $s0 # B[i] + c sw $t4, 0($t2) # store in A[i] addi $t0, $t0, 1 # i++ addi $t2, $t2, 4 # ptr to next A[i] addi $t3, $t3, 4 # ptr to next B[i] bne $t0, $t6, loop # if i < 101, goto loop IF ANY QUERIES REGARDING CODE…

    • 107 Words
    • 1 Page
    Powerful Essays
  • Satisfactory Essays

    Coverage area: The space in which the wireless radio signals in one wireless LAN can effectively reach and be used to send and receive data between the WLAN’s AP’s and it’s clients…

    • 356 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Xcom285 Week 7 Syllabus

    • 287 Words
    • 2 Pages

    ***Please remember to post your assignment via a Word Document, within the Assignments section of this course. Thank you. J…

    • 287 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Application: Generally, a function on any kind of computer or electronic device that is useful to the user, which can give the user a reason to want to own and use the device. More specifically, software that performs some useful function for a user.…

    • 539 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    2. Provide a 100- to 200-word summary in which you provide an example business that you would start for each form. What is legally necessary to file in order to form that business? Discuss at least one of the advantages and one of the disadvantages of that form.…

    • 1314 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    List the relational operators and logical operators that can be used to form a validation rule.…

    • 636 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Chapter 4 Quiz Week 2

    • 537 Words
    • 2 Pages

    Read the following business requirements closely to determine the entities and relationships needed to fulfill the requirements. The nouns in the paragraph will tell you the entities that will be needed. The verbs in the paragraph will help you determine the relationships between the entities.…

    • 537 Words
    • 2 Pages
    Better Essays
  • Satisfactory Essays

    2. Provide a 100- to 200-word summary in which you provide an example business that you would start for each form. What is legally necessary to file in order to form that business? Discuss at least one of the advantages and one of the disadvantages of that form.…

    • 2039 Words
    • 9 Pages
    Satisfactory Essays
  • Powerful Essays

    Bus Law203

    • 2307 Words
    • 10 Pages

    You are to work on this assignment alone without assistance from others; however, you may use your text, class lectures and your notes in completing the assignment.…

    • 2307 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    Write a policy for each of the above, and write a procedure to explain how each of the policies will be implemented. Four policies are four procedures are required…

    • 1999 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Unit 37

    • 1183 Words
    • 4 Pages

    1.2 + 1.3: We have regulations and guidelines with policies and procedures to follow to protect the client for example hear are just a view ways in which we must do this:…

    • 1183 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Bounce Fitness

    • 745 Words
    • 3 Pages

    The business is operated on best business practice and complies with all legislative requirements, local by-laws and is registered with the national body.…

    • 745 Words
    • 3 Pages
    Good Essays

Related Topics