Reference no: EM131324043
Assignment
This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ability to reach third normal form for your design, your mastery of how to "break" fields in to sub-fields to access data individually, and your ability to reach the desired goals with the fewest number of fields (without being SO clever that easily understanding your system is an issue). Your completed project must be word-processed and follow this format for the table notation. Table name bolded. Names of the fields in each table with the primary key field(s) underlined. All foreign keys indicating the table name they link to. Do not provide any other details, such as, field length or type.
Correct example: Customer (customerid, fname, lname, salespersonid Salesperson table) Your system should be able to provide the following information:
- Customer bio (name, address, phone, driver's license)
- Videos in the library
- Videos that are rented out
- Info on each video (format (VHS, Beta, DVD, BluRay), length, rental price, cost, rental time period, genre of video - comedy, action, quantity of categories unknown.)
- Who has what rented out
- How much money was taken in per day, week, month, year
- A customer's rental history and if they paid late fees on a rental
- How many times a video is rented in a specific time period
*** Make sure to list your business rules that dictate the assumptions you make during design.
|
Which of the them arrangement would give highest product
: Two stirred tanks of volume "V" and "2V" are available for carrying out a first order irreversible reaction at constant density and temperature. If the flow rate of feed stream is "Q" which of the following arrangement would give highest productio..
|
|
Showing discrete work tasks
: A Work Breakdown Structure (WBS) and Gantt chart, developed as an MS Project file, showing discrete work tasks, grouped hierarchically in a way that helps to organize and define the total work scope of the project for team project having trouble.
|
|
Provide a reflection on weeks group activity
: The assignment is to provide a reflection on this weeks group activity - regrading the consulting of a new business (clothing store) in terms of management and marketing the business.
|
|
Describe the clinical features of the anxiety disorders
: PSY 2010: Discuss the genetic, neurobiological, social, and psychological factors that contribute to the mood disorders. Describe the symptoms, the diagnostic criteria, and epidemiology of mood disorders. Identify the medication and psychological tr..
|
|
How much money was taken in per day week month and year
: How much money was taken in per day, week, month, year? How many times a video is rented in a specific time period? A customer's rental history and if they paid late fees on a rental.
|
|
Practices of allopathic vs homeopathic medicine
: As it relates to the practices of allopathic vs. homeopathic medicine, has one method proven to be more effective than the other over time? Your response should be at least 75 words in length.
|
|
Examples of the medical dominance of physicians
: Give at least three examples of the medical dominance of physicians. In your opinion, should physicians have as much power as they do? Why, or why not? Your response should be at least 75 words in length.
|
|
How many times should given two media be used
: How many times should each of the two media be used to obtain maximum exposure while staying within the budget? Use the graphical method to solve.
|
|
Government implementation of drgs
: Explain why DRGs were developed, and how they were designed to function. In your opinion, has the government's implementation of DRGs done an effective job of keeping doctors within cost limits when treating patients? Your response should be at le..
|