Preview

Anime LIst

Good Essays
Open Document
Open Document
11441 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Anime LIst
HYPERLINK "https://dcccd.blackboard.com/webapps/blackboard/content/listContent.jsp?course_id=_29945_1&content_id=_1989014_1" Chapter 1 Assignments
Which of the following represents a row in a table? a record
Which of the following defines a relationship in which each occurrence of data in one entity is represented by multiple occurrences of the data in the other entity? one-to-many An entity is represented in an E-R model as a(n):
Arrow
Which of the following is not an E-R model relationship? some-to-many Which of the following symbols represents a many-to-many relationship in an E-R model?
A straight line with a crow’s foot
Which of the following can contain repeating groups? unnormalized data
Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity? one-to-one Which of the following has no partial or transitive dependencies?
3NF
Which of the following symbols represents a one-to-many relationship in an E-R model? straight line with a crow’s foot at the “many” end
Which of the following has no partial dependencies but can contain transitive dependencies?
2NF
Which of the following has no repeating groups but can contain partial or transitive dependencies? 1NF
The unique identifier for a record is called the: primary key
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value? primary key
A unique identifier for a data row that consists of more than one field is commonly called a: foreign key
Which of the following symbols represents an optional relationship in an
E-R model?a dashed line
Which of the following, when used in an E-R model, indicates the need for an additional table? one-to-many relationship
Which of the following represents a field in a table? a column
Which of the following defines a relationship in which data can have multiple



References: ORDER Which of the following SQL statements returns all books published after March 20, 2005? SELECT * FROM books WHERE pubdate 4 '03–20–2005 '; Which of the following lists all books published before June 2, 2004 and all books published AND pubdate 5 '06–02–2004 '; Which of the following finds all orders placed before April 5, 2009 that haven’t yet shipped?

You May Also Find These Documents Helpful

  • Good Essays

    An entity relationship diagram (ERD) is a graphical documentation technique used in the designing of database within organizations to describe the entities and their direct relationships (Bagranoff, Simkin, & Strand, 2008). The ERD diagram consists of entities, attributes, and relationship. The entity represents a rectangular; the diamond is symbolized by describing the relationship of the entities, oval shape describes the attributes, and the lines connect all three to describe their relationship. Attached is an ERD of Kudler Fine Foods showing their existing data tables.…

    • 496 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    10 T | Functional dependencies consist of groups of related attributes that form subsets within an entity.…

    • 313 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    7) In a one-to-many relationship, each row on in the primary key table can be related to any number of rows in the foreign key or child table.…

    • 613 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    cis3730_Exam1_Studyguide

    • 512 Words
    • 2 Pages

    Be able to give examples of tables, specify their primary keys, and explain how they are related through foreign keys.…

    • 512 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The Entity Relationship Diagram, also known as (ERD) demonstrates the relationship between data in the new database. ERD shows the logical path that the data follows. The data model gives one understanding and the visual representation to observe the different phases of the database and determine the path the information is pulled or stored from. Learning Team D demonstrate linking the different tables in the Fleet Truck Maintenance database. The creation of the logical path predicts the flow of the data entered and the tables relationship to other tables in the database.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    5. (TCO 2) A collection of related data items that are specific to an instance of an entity, such as all the data about a specific employee, is (Points : 4)…

    • 368 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Pt2520 Final Answers 1/3

    • 329 Words
    • 2 Pages

    which of the following best describes an attribute that can be primary key? candidate key…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. Consider a table of data about employees. Which of the following fields are keys? Which one would you choose as the primary key? Employee ID Why? Because it is a unique number assigned to each employee.…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Unit 3 research

    • 383 Words
    • 2 Pages

    An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes…

    • 383 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    IST223 Crib sheet

    • 3425 Words
    • 7 Pages

    rectangles, and relationships are shown by lines between the rectangles. Attributes are generally listed within the rectangle. The many side of many relationships is represented by a crows footentity-relationship (E-R) modelA set of constructs and conventions used to create data models. The things in the users world are represented by entities, and the associations among those things are represented by relationships. The results are usually documented in an entity-relationship (E-R) diagramID-dependent entityan entity whose identifier includes the identifier of another entityidentifierwhich are attributes that name, or identify, entity instancesidentifying relationshipIn such relationships, the parent is always required, but the child (the ID-dependent entity) may or may not be required, depending on application requirements. Identifying relationships are shown with solid lines in E-R diagrams.is-aRelationships among supertype/subtype entitiesmandatoryat least one entity instance must participate in the relationshipmaximum cardinalityThe maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.minimum cardinalityThe minimum cardinality is the minimum number of entity instances that must participate in a relationship instance.nonidentifying relationshiprelationship drawn with a dashed line (refer to Figure 5-7) is used between strong entities and is called a nonidentifying relationship because there are no ID-dependent entities in the relationship.null valueare a problem because they are ambiguous. They can mean that a value is inappropriate, unknown, or known, but not yet been entered into the databaseparentAn entity or row on the one side of a one-to-many relationshiprecursive relationshipoccurs when an entity type has a relationship to itself.relationship classAssociations among entity classesrelationship instanceassociations among entity instances.strong entityan entity that represents something that can exist…

    • 3425 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    poop

    • 796 Words
    • 4 Pages

    3. A relationship is a group of related tables that share a common attribute. A one-to-many relationship is when there is one entity table that relates to many entities table, but not vice-a- versa.…

    • 796 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor…

    • 906 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Week 4 MGMT340 Assignment

    • 538 Words
    • 3 Pages

    f. TOOL could be modeled as an associative entity along with EMPLOYEES and PROJECTS. An associative entity type is one that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. For example, EMPLOYEES can use TOOL and PROJECT will also need TOOL. TOOL can used by EMPLOYEES for PROJECTS.…

    • 538 Words
    • 3 Pages
    Good Essays
  • Good Essays

    One entity connects to another one entity that has only one instances. For example, one Employee allows having one parking lot. In the ERD diagram, it represented by normal single line at both entities as figure 40…

    • 935 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Structure Query Language

    • 4327 Words
    • 18 Pages

    Two tables can be related using a common attribute. When a primary key of one table is also available as an attribute in another related table it is called a foreign key.…

    • 4327 Words
    • 18 Pages
    Better Essays

Related Topics