RDBMS CONCEPTS

 

The use of keys are instrumental in database management. Primary keys  allow for distinct records and foreign keys tie records together to  create unique relationships between two or more entities and/or tables.  In Blockchain, we know that a hash is the equivalent to a key – and  makes the chain secure and indisputable (or so we think). Why is it then  that with an RDBMS, a primary key and foreign key can still create  redundancy, thereby causing data anomalies? Can the same be said about  blockchain?

Instructions

  • This is a required assignment, worth 15 points. The assignment  must be submitted by the due date. Late assignment are not allowed. 
  • You are required to submit a minimum of two postings. Points will be deducted for not fulfilling this minimum requirement.
  • Apply and use the basic citation styles of APA is required. Points are deducted per the rubric for this behavior.
  • Do not claim credit for the words, ideas, and concepts of  others. Use in-text citation and list the reference of your supporting  source following APA’s style and formatting. Points are deducted per the  rubric for this behavior.
  • Do not copy and paste information or concepts from the Internet  and claim that is your work. It will be considered Plagiarism and you  will receive zero for your work. A second offense results in a zero for  the course. A third is termination from the university.