Reference no: EM13328944
Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle's relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business-they are also used to support the activities of managers.
For this assignment, you will be analyzing the data in a simple, one-table database by creating queries and reports in Microsoft Access. The system you are "developing" will be used by The Queen's Inn in St. John's, Newfoundland for strategic business development purposes.
Remember that Access, Excel, and even FrontPage, are all tools. This assignment will help you discover how to use a database tool to support a business. You will be analyzing the data in the database and answering the questions in the exercise to create the queries and reports that are necessary to determine what the Inn's current business situation is.
• Analyze the data in the database and in the application exercise.
• To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).
• Create queries and reports that will provide information to help management at the Queen's Inn to be more competitive and profitable. If you look at the original database you downloaded, you will see that it provides suggestions for the three reports that should be created for The Queen's Inn. These empty templates will give you an indication of what queries and reports you must create for this assignment.
Write a brief report (1-2 pages) describing what database information (from your analysis) would make the business more competitive and profitable. Your report must include, at a minimum, answers to the four questions in the last paragraph of the exercise on page 93 of the textbook.
|
Determine minimum variance portfolio with expected return
: Stock B has expected return of 16% and standard deviation of 35%. Stock C has expected return of 12% and standard deviation of 22%. Their returns have correlation of 0.15.
|
|
Determine the radius of the circular path
: An electron moves in a circular path perpendicular to a constant magnetic field with a magnitude of 1.00 mT. Determine the radius of the circular path
|
|
Concentrate on the aggregate supply effects
: Suppose the government spends more on building new infrastructure. Assume that the new infrastructure projects are useful and make the economy more efficient. What is the effect on the long-run level of output and the price level? Concentrate on the ..
|
|
Causes and problems with employee attitudes and behaviou
: The concept of the psychological contract tells us much about the causes and problems with employee attitudes and behaviour.
|
|
Analyze the data in the database and in application exercise
: To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).
|
|
Determine the moment of inertia of the molecule
: The rotational spectrum of the HCl molecule contains lines with wavelengths of 0.0604, 0.0690 ,0.0804 ,0.0964 , and 0.1204 mm. What is the moment of inertia of the molecule
|
|
Prepare an income statement for the year ended
: Prepare an income statement for the year ended December 31, 20X6, by using direct costing and prepare an income statement for the year ended December 31, 20X6, by using absorption costing.
|
|
Draw his daily budget constraint in a 16hour day
: "Anjali and Sanu are married, and Sanu is the breadwinner. Anjali provides 4 non-market hours of service daily, and her productivity at home is $15. Sanu's earnings are $20/hour, and his productivity at home is $10/hour. Draw his daily budget constra..
|
|
Create a gantt chart illustrating the project tasks
: Write clearly and concisely about Systems Analysis and Development topics using proper writing mechanics and technical style conventions.
|