Preview

assign1

Satisfactory Essays
Open Document
Open Document
309 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
assign1
Introduction to Database Design
IS410/610 Section 0301, Fall 2014
Assignment 1
Due before the class on Thursday, Sept. 18
Model the following case description with (E)ERD and turn in a hardcopy that is typed and printed.
This deliverable should include the following items:
 an (E)ER diagram (8 pts)
 additional constraints/ business rules not shown on the diagram, if any. The constraints/rules should be written in English. (1 pt)
 additional assumptions, if any (1 pt) iVideo, a local video renting shop, is considering creating a database to keep track of various aspects of the store. Impressed by your IS knowledge and skills, the management has decided to hire you to design a conceptual data model first. iVideo has films of various genres (such as Drama, Horror, Action, Comedy, Foreign,
Educational) for rent. Each film is uniquely identified by a Film ID. Each film is also described by a title, a rate, its genre, and possibly one or more directors. For some special kinds of films, more information is recorded. For instance, each foreign film has a spoken language and a subtitle language. Each educational film has a recommended age group, which can take the values of “infant”, “child”, “teenager”, “adult”, and “senior”. iVideo carries zero or more DVD copies of each film. Each copy has an index number that is unique among all the copies of the same film. But copies of different films may have the same index number. iVideo allocates a unique customer ID for each customer. Other information about a customer includes name (first name, middle initial, and last name), address (street, city, state), phone number, birth year (to compute age), and total rental amount.
Every time a customer wants to rent some copies of films, iVideo database should records the checkout date, due date, and amount paid. A customer with an age under
18 cannot rent a film rated “18 or above”.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Unit 1 Assignment 1

    • 306 Words
    • 4 Pages

    In 2010, the processor model that was the first to have two billion transistors on its chip was known as the Quad-Core Itanium Tukwila.…

    • 306 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 1 Assignment 1

    • 126 Words
    • 1 Page

    As the number of computers in a company network grows, so does the administrative overhead involved in maintaining the computer network. DNS and DHCP can keep the overhead to a background task.…

    • 126 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Even tho Redbox as many newly released movies they charge by the amount of movies…

    • 301 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Unit 1 Assignment 1

    • 266 Words
    • 1 Page

    The Johnson Company can do several things to reach out to new customers. Even though many companies still use them, the yellow pages are all but obsolete and viewed by a low number of people. Most companies utilize websites and social media to attract customers. The Johnson Company can create these to get their name out on the internet. In conjunction with these websites, they could utilize web advertising services such as Google advertisements or banner ads. Additionally, they could contact their local cable providers to film commercials to air on television.…

    • 266 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Unit 1 Assignment 1

    • 357 Words
    • 2 Pages

    a. Learning how to help students in learning behaviors that I want them to demonstrate in the classroom.…

    • 357 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    assignement 1

    • 1282 Words
    • 4 Pages

    2. List two examples of goods you have purchased in the past or may purchase in the future. (Complete sentences are not necessary. 0.5 points)…

    • 1282 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Assignment 1 of 4 1

    • 359 Words
    • 2 Pages

    I have been asked by my lecturer, Jo Chapman, to produce a report on the differences types of business ownerships of two contrasting organisations. For the purposes of this report, I will look at the different types of ownerships of Tesco and NSPCC. I will also investigate the purpose, sector and liability of both organisations.…

    • 359 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 1 assignment 1

    • 405 Words
    • 2 Pages

    1. Briefly, what does the process of installing an operating system such as Fedora/RHEL involve?…

    • 405 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The movie studios and the video rental stores have combined stakes in the success of a movie. A successful movie ensures higher returns from exhibitions in theatres and increased rental revenues by…

    • 737 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Unit 1 Assignment 1

    • 286 Words
    • 1 Page

    In order for a large public health care organization to stay operational, the organization must follow many compliance laws. There are many compliance laws set in place for many health care organizations. For a health care organization of this size, there are few compliance laws that must be adhered too; Health Insurance Portability and Accountability Act (HIPAA), Payment Card Industry Data Security Standard (PCI DSS), and Sarbanes-Oxley Act (SOX).…

    • 286 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Four Little Girls

    • 256 Words
    • 2 Pages

    • Go to the list and pick your film. You must view the entire film. If you can’t access films because of deployment, geographic location, or other reasons, please let your instructor know so they can give you an alternate assignment.…

    • 256 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Music In Film F14 Syllabus

    • 2373 Words
    • 9 Pages

    Students are responsible for viewing the films to be studied in this course. The films will be…

    • 2373 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Lean on Me

    • 1324 Words
    • 6 Pages

    References: Boggs, Joseph M; Petrie, W Dennis (2008) The Art of Watching Films 7th Edition The Mc Graw Hill Companies, Inc…

    • 1324 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    assign

    • 341 Words
    • 2 Pages

    You are responsible for proofreading, editing and using software tools, such as spell checking and grammar checking PRIOR to submission. If this written assignment is rated unacceptable on any criteria, you will be referred to the COB Writing Lab to resubmit your paper with penalty. You will find the COB Writing Lab is listed in your menu of courses when you login to Blackboard Learn. The COB Writing Lab contains resources that you can access any time to improve your writing skills. In addition, you can request to meet via online or face-to-face with a professional writing tutor, Ms. Robin…

    • 341 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Project Proposal for a Database Database for a Bank Introduction: This database is created for a bank which can keep track of their customer’s and account holders’ details and transactions. With the above aim they should be able to have access to the information mention in real time. This will help the management to take decisions and also will make the record and finance staff work more organized.…

    • 1050 Words
    • 5 Pages
    Good Essays