Optimization Strategies | Graded Now that you've seen both the logical and physical side of databases,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Optimization Strategies | Graded Now that you've seen both the logical and physical side of databases, let's consider how to design a database to fulfill our business needs. Imagine you are tasked with designing a database that encompasses the Learning Management System (LMS) that you use on a daily basis. The following requirements hold: . Typical online student enrollment is 3,000 annually Access is password protected There should be a feature to create new accounts with different roles A role (faculty, student, staff) may have access to only certain features Students can be enrolled in multiple courses Faculty can teach multiple courses/sections . . Student records must be kept indefinitely Users should have near 24/7 access (with one hour of downtime allotted per month) The most frequent operations from a student perspective are posting discussions, taking exams, uploading assignments, checking grades, and emails The most frequent operations for faculty are posting discussions, changing course content, grading, and emails The most frequent operations for staff are to enroll students, create new sections, and assign sections to faculty What would be your initial design? Provide both a logical and physical approach. For your logical suggestion, provide an E-R model of how the system might look and then provide support that it will be efficient given the operations. For the physical design, provide an outline of strategies and infrastructure you would put into place to support the business requirements. Optimization Strategies | Graded Now that you've seen both the logical and physical side of databases, let's consider how to design a database to fulfill our business needs. Imagine you are tasked with designing a database that encompasses the Learning Management System (LMS) that you use on a daily basis. The following requirements hold: . Typical online student enrollment is 3,000 annually Access is password protected There should be a feature to create new accounts with different roles A role (faculty, student, staff) may have access to only certain features Students can be enrolled in multiple courses Faculty can teach multiple courses/sections . . Student records must be kept indefinitely Users should have near 24/7 access (with one hour of downtime allotted per month) The most frequent operations from a student perspective are posting discussions, taking exams, uploading assignments, checking grades, and emails The most frequent operations for faculty are posting discussions, changing course content, grading, and emails The most frequent operations for staff are to enroll students, create new sections, and assign sections to faculty What would be your initial design? Provide both a logical and physical approach. For your logical suggestion, provide an E-R model of how the system might look and then provide support that it will be efficient given the operations. For the physical design, provide an outline of strategies and infrastructure you would put into place to support the business requirements.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
How much momentum does a car of mass 1 5 0 2 KG have a travels at a consistent speed of 1 4 . 3 m / s?
-
1. Identify and classify all the key people involved in the crime including perpetrators and victims. Give all necessary background on the key players. 2. Thoroughly explain the type of crime...
-
Use Thevenins Theorem to Find Io in the circuit shown # 2Vx Io
-
A square loop \(0.20 \mathrm{~m}\) on each side is placed in a uniform magnetic field of magnitude \(0.50 \mathrm{~T}\). The plane of the loop makes a \(30^{\circ}\) angle with the magnetic field....
-
Assume the source selection criteria for evaluating proposals is as follows: Management approach, 15% Technical approach, 15% Past performance, 20% Price, 20% Interview results and samples, 30% Using...
-
1. Consider two satellites S and S with periods of revolution 1hr. and 8 hr. respectively revolving around a planet in circular orbits. The ratio of angular velocity of satellite S to the angular...
-
You have $ 5 , 0 0 0 to invest for the next year and are considering 2 0 - year corporate bond offering a yield to maturity of 7 . What is the risk profile of each of these assets?
-
What are the federal exemptions debtors can exclude from the bankruptcy process?
-
Classify each of the following items as excludable, nonexcludable, rival, or nonrival. Explain your answer. A public beach in Greece An IKEA chair A movie at the local cinema A view of Mount Fuji
-
Imagine you are working as a salesperson for a household goods retailer selling items such as fridge freezers, furniture and bedding, and televisions, for example. Pick one product category and write...
-
Discuss the reasons why more and more distribution channels are being characterized by a small number of large central distribution centres rather than by a large number of relatively small outlets.
-
What is the objective of piercing the corporate veil?
-
Q.4 Suppose we have the following student table in database. You have to write: Form load event to show all records in grid view when you run the application Event handler for "Semester 6th Student"...
-
What is an access control list?
-
What is represented by the labeled lines connecting entities in an REA diagram?
-
In the flat-file data management environment, users are said to own their data files. What is meant by the ownership concept?
-
Many authorities believe that the employer does not prosecute 90 percent of all computer fraud acts. What do you think accounts for this lack of prosecution? Discuss the importance of the...
-
Maribel Ortiz is puzzled. Her company had a profit margin of 10% in 2025. She feels that this is an indication that the company is doing well. Gordon Liddy, her accountant, says that more information...
-
At December 31, 2025, the fair value of non-trading securities is 41,300 and the cost is 39,800. At January 1, 2025, there was a credit balance of 900 in the Fair Value Adjustment Non-Trading...
-
On January 1, 2025, Lennon Enterprises acquires 100% of Ono Ltd. for 220,000 in cash. The condensed statements of financial position of the two companies immediately following the acquisition are as...
Textbook Of Environmental Chemistry And Pollution Control 1st Edition - ISBN: 8121908833 - Free Book
Study smarter with the SolutionInn App