MIS 605 Topic 2 DQ 2 (Latest Update) Verified and Rated A+
MIS 605 Topic 2 DQ 2 In the Topic Materials you read "Codd's 12 Rules" and learned about how in 1985, Dr. E. F. Codd developed the rules for an ideal relational database. Although all of the rules were not actually used, explain why they have served as a guideline for developers over the last few decades. Provide specific examples to support your ideas. Codd’s 12 rules is a set of rules that a database management system (DBSM) must have if its to be considered relational. These rules were established to specify a set of criteria that could be used to determine if a database management system could be considered relational or not. If a DBMS has all of Codd’s rules, then it is considered to be a relational DBMS. If not all the rules are there, then it is not a relational database management system. Codd’s wrote these rules in an attempt to preserve the original vision of the relational model. But database vendors liked to repackage their existing DBMS products as relational DBMS without necessarily making the product follow all of Codd’s 12 rules. A relational DBSM stores data in tables, which has rows and columns. With a relational database, data can be easily accessed to. By using the rules as a guideline, it becomes easier to input, find, and access data than using other methods. Also, the data is easily understood because of the relational database, the data has been given context. IAN. (2017, October 2). Codd's 12 rules. DATABASE.GUIDE. Retrieved from
Written for
- Institution
-
Grand Canyon University
- Course
-
MIS 605
Document information
- Uploaded on
- April 28, 2023
- Number of pages
- 1
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
mis 605 topic 2 dq 2 in the topic materials you read codds 12 rules and learned about how in 1985
-
dr e f codd developed the rules for an ideal relational database although all of the