Grantham University Relational Model Database Applications Questions

Part I.

Please include the questions with your answers. Answer in complete sentences where applicable.

  1. List the characteristics that a table must have to be considered a relation.
  2. List two synonyms for “file,” two for “record,” and two for “field.”
  3. What are the four uses of a primary key?
  4. What are the desirable characteristics of a primary key?
  5. What is a surrogate key and when do you use them?
  6. What is a foreign key?
  7. What is referential integrity and why is it important?
  8. What are the three possible interpretations of a null value?
  9. What is normalization? Why is it important?

Part II.

After you install Microsoft Access, please use the Microsoft Website Support of Getting Started to learn the steps of creating a database for your assignment. You find the tutorials

Using Microsoft Access, create a small database of your own (do not use the examples given in the text or lectures). The database should have two tables that have a relationship through a foreign key. In this document please tell me the name of the primary key of each table and the name of the foreign key.

Please save your database and submit the database file (.accdb file) to this assignment in addition to the Word document containing the 9 questions here.

You can leave a response, or trackback from your own site.


15 Responses to “Grantham University Relational Model Database Applications Questions”

  1. 65783 891712youve got an essential weblog proper here! would you wish to make some invite posts on my weblog? 610665

  2. 972888 560626Your weblog has exactly the same post as another author but i like your better.~:; 734334

  3. 343968 363475 An intriguing discussion is worth comment. I think which you need to write much more on this subject, it may well not be a taboo topic but generally people are not enough to speak on such topics. Towards the next. Cheers 625933

  4. 285735 170538You completed certain excellent points there. I did looking on the subject matter and located most persons will go together along with your blog 214765

  5. 976260 579814I see something truly fascinating about your web web site so I saved to bookmarks . 990815

  6. 576376 223358Its superb as your other posts : D, regards for posting . 717939

  7. 316936 741231My spouse and I stumbled over here from a different internet site and thought I may possibly as nicely check things out. I like what I see so now im following you. Look forward to going more than your web page repeatedly. 719788

  8. 796555 302637Its amazing as your other weblog posts : D, thanks for posting . 983322

  9. 마루마루 says:

    687175 940332I enjoy searching via and I conceive this site got some truly helpful stuff on it! . 89531

  10. 538452 496888I just want to tell you that Im quite new to weblog and honestly liked this internet internet site. Far more than likely Im planning to bookmark your weblog post . You definitely come with exceptional articles and reviews. Bless you for sharing your web internet site. 336558

  11. The operation is 28,800 and 1 hour.

  12. A special sports party.

  13. 3d printer says:

    435305 887822The great intreguing articles maintain me coming back here time and time once more. thank you so much. 360239

  14. 275346 705643woah i like yur web site. It genuinely helped me with the information i wus seeking for. Appcriciate it, will bookmark. 338060

  15. 835152 208107As soon as I discovered this web site I went on reddit to share some with the enjoy with them. 802368

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes