What separates a personal DBMS from an enterprise-level DBMS?

  • What are the different database models? How do these models compare with the relational model?
  • Do the various database models store and retrieve data differently? Explain?
  • What is SQL and for what purpose is it used in databases?
  • What is referential integrity and why is it important?
  • What is database concurrency and what does it prevent?
  • A database is self-describing. By what other name is this attribute known as?
  • What are the functions of a DBMS? List them and provide a brief but meaningful description of each.
  • What separates a personal DBMS from an enterprise-level DBMS?
  • Database design is important and full of challenges. Many databases are poorly designed. What are the characteristics of a poor database design?
  • What are the three types of database design?
  • In what year was the relational model developed and who developed it?
  • What other DBMS constructs came after relational databases?