A group of database tables from which you can make connections between 6 A

A group of database tables from which you can make

This preview shows page 4 - 7 out of 7 pages.

A group of database tables from which you can make connections between6.A question using the syntax that the database software can understand7.The connection between two tables8.The process of returning the database to a correct form that existed before an error occurred9.Occurs when two database users need to modify the same record at the same time1.ANS: DPTS:1REF:5862.ANS: GPTS:1REF:586
Background image
3.ANS: APTS:1REF:5864.ANS: EPTS:1REF:5875.ANS: BPTS:1REF:5886.ANS: FPTS:1REF:5977.ANS: HPTS:1REF:6008.ANS: CPTS:1REF:6199.ANS: IPTS:1REF:619SHORT ANSWER1.Discuss how to create databases and table descriptions.ANS:Creating a useful database requires planning and analysis. You must decide what data will be stored, how that data will be divided between tables, and how the tables will interrelate. Before you create anytables, you must create the database itself. With most database software packages, creating the data-base that will hold the tables requires nothing more than naming it and indicating the physical location,perhaps a hard disk drive, where the database will be stored. When you save a table, it is conventional to provide a name that begins with the prefix “tbl”—for example, tblCustomers. Your databases often become filled with a variety of objects—tables, forms for data entry, reports that organize the data for viewing, queries that select subsets of data for viewing, and so on. Using naming conventions, such as beginning each table name with a prefix that identifies it as a table, helps you keep track of the objects in your system. Before you can enter any data into a database table, you must design the table. At minimum, this in-volves two tasks:• You must decide what columns your table needs, and provide names for them.• You must provide a data type for each column.PTS:1REF:588-5892.Discuss the use of null values within a database table.ANS:Unassigned variables within computer programs might be empty (containing a null value), or might contain unknown or garbage values. Similarly, columns in database tables might also contain null or unknown values. When a field in a database contains a null value, it does not mean that the field holds a 0 or a space; it means that no data has been entered for the field at all. Although null and empty are used synonymously by many database developers, the terms have slightly different meanings to some professionals, such as Visual Basic programmers.PTS:1REF:5903.List two examples of primary keys.
Background image
4.List three reasons why a primary key is important.
Background image
Image of page 7

You've reached the end of your free preview.

Want to read all 7 pages?

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes