BUAN 674_Discussion2 W3
docx
keyboard_arrow_up
School
University of the Cumberlands *
*We aren’t endorsed by this school
Course
674
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by shrey2508
Example: University Course Registration System
1.
Database Model(s):
Relational Database Model
2.
Right Choice? Why or Why Not:
Yes, it's the right choice:
The relational model is well-suited for structured data, such as student information, course details, and schedules (E. F. Codd, 1970).
Its ability to handle complex queries and transactions aligns with the requirements of a university course registration system.
The normalization process in the relational model ensures data integrity by minimizing redundancy (E. F. Codd, 1970).
3.
Implications of the Choice:
Enables:
Efficient management of student records, grades, and course schedules due to the relational model's well-defined structure (Elmasri & Navathe, 2015).
Seamless integration with other university systems, fostering a cohesive and interconnected information environment.
Restricts:
Challenges may arise when dealing with highly interconnected data or unstructured information (Elmasri & Navathe, 2015).
4.
Revisit Decision? Why or Why Not:
No, wouldn't choose a different model:
The relational model continues to align with the structured nature of student data.
Switching to another model may disrupt existing systems and require significant migration efforts, posing potential risks to data integrity and
system stability (Coronel et al., 2016).
Additional Considerations:
Scalability:
While the relational model excels in structured data, scalability challenges may arise with an exponential increase in data. Consideration of NoSQL databases could be explored for scalability improvements (Silberschatz et al., 2019).
Future Trends:
Keep an eye on emerging trends in database management, such as NoSQL databases, and evaluate them based on evolving business needs and technological advancements.
Reference:
E. F. Codd (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, 13
(6), 377–387. https://doi.org/10.1145/362384.362685
Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems
(7th
ed.). Pearson.
Coronel, C., Morris, S., & Rob, P. (2016). Database Systems: Design, Implementation, & Management
(12th ed.). Cengage Learning.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts
(7th ed.). McGraw-Hill Education.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help