Reference no: EM13762335
The More Movies company has hired you to redesign a database system for them that can facilitate the process of renting out and returning movies.
They already have an Oracle database that stores information about movies, members who rent the movies, and the rentals. This is the database that you already have become familiar with and the one which includes tables: MM_MOVIE, MM_MOVIE_TYPE, MM_MEMBER, MM_RENTAL, and MM_PAY_TYPE. The machine on which this database is running has both the server and client Oracle9i software installed on it. Every night, a clerk updates data to account for the day's activities, and periodically the reports are run to summarize business, show renting trends, etc. Access to the database is accomplished using a SQL*Plus environment that is very similar to the iSQL*Plus that you know from the previous database course. This business process worked okay for as long as More Movies stayed a very small business.
However, the company has grown substantially, expanding its operations to more movie selection and more members, and consequently, it has moved to a larger location. It occupies a two-story shop now. It became very impractical to record rentals at the end of the day. They also do not want to rely on clerks knowing any SQL programming in order to record updates and run reports.
In short, there is a need for a more convenient database system. The machine on which the database is currently running is powerful enough to host the database server. The database should be accessible from four checkout stations that process renting out and returning movies.
This system should have an easy-to-use graphical user interface access.
For the lab, you will be creating several documents to be submitted for the lab. Be sure that you save the documents with your last name and lab7 in the file name. Place all documents into a single ZIP file and submit for grading.
|
Describe a file system
: Theory-long answer question. Describe how a file system could be implemented using a collection of inodes and some variant of a B tree. 500-1000 words. Be sure to consider: unallocated space, bad allocations, lost and found, root directories, s..
|
|
What are the strengths of estimates within an organization
: When working on a project estimating the duration of each part of the work is very important. What are the strengths of estimates within an organization having consistent estimates? What are the weaknesses?
|
|
What chiefly distinguishes modern times from previous times
: What chiefly distinguishes modern times from previous times? Why is it erroneous to agrue that the nature of the two sexes makes their present relationship appropriate?
|
|
Dating and timing of physician orders
: Prepare a 2-3 page report describing, comparing and/or contrasting the specific standards that apply to the authentication, dating and timing of physician orders, and make a recommendation as to what the policy for your hospital should be.
|
|
Convenient database system
: In short, there is a need for a more convenient database system. The machine on which the database is currently running is powerful enough to host the database server. The database should be accessible from four checkout stations that process rent..
|
|
Accounting field and accounting job postings
: Use the Internet or the Strayer Online database to research career options within the accounting field and accounting job postings in your local area to respond to the questions in the assignment.
|
|
E-mail that promotes product or service
: is unsolicited e-mail that promotes product or service, or they be part of hoax: Infare wireless networks that pretend to offer trustworthy WI-FI connection to the Internet
|
|
Research paper tcp/ip protocol hierarchy
: Write a 2 page research paper (excluding the title and reference pages) on five-layer TCP/IP protocol hierarchy. Use three other resources (Wikipedia sources are not permitted) and list each resource used at the end of the paper in the reference l..
|
|
Compute the netindex return between periods
: Draw the event tree of economy. For both nodes at t=1, compute the netindex return between periods 0 and 1. What is the expected return of the indexbetween t = 0 and t = 1?
|