Nt2520 Unit 3 Assignment 1

Good Essays
Unit 3 Assignment 1: Homework
Learning Objectives and Outcomes
Use the database modeling template in MS Visio.
Create entities and add attributes of a database.
Define relationship between entities of a database.
Create many-to-many relationships with a linking table.

Assignment Requirements
Answer the following True or False questions on the student answer sheet.

Required Resources
Textbook

Submission Requirements
Submit your written answers to your instructor at the beginning of Unit 4.

Unit 3 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.

1) The logical design is independent of any database management system.

2) The physical design is the logical design adapted to the constraints and features of the database management system.

3) You should always try to create cross relationships between parent and tables.

4) Naming conventions help support clarity and consistency in database design.

5) One to one relationships between entities are valid but rare.

6) Crow’s feet notation conveys more information about cardinality than arrow notation.

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.

8) Cross relationships between parent and child tables can make data entry impossible.

9) Maximum cardinality refers to the maximum number of records allowed in a table.

10) Minimum cardinality is the smallest number of records allowed in a related table.

11) A linking entity is an entity that is used to resolve a many to many relationship into two one too many relationships.

12) A weak entity is dependent on another entity for its meaning.

13) The following diagram is an example of a one-to-one relationship.

14) The following diagram is an example of a many-to-many relationship.

15) Many-to-many

You May Also Find These Documents Helpful

  • Satisfactory Essays

    unit 3 nt2520

    • 419 Words
    • 2 Pages

    An issue in today’s world is the environment. There is dispute over what we should do about it. One issue in the environment is global warming. Global warming has become a problem around the world; it is caused by CO2 emissions and other gases in the atmosphere that cause the sun’s thermal energy to be absorbed, otherwise known as the greenhouse effect. Studies have shown that at least 20% of ice on Earth has melted since 1979. Although it may not sound so bad, every year we deplete the natural…

    • 419 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Unit 3 assignment 1

    • 479 Words
    • 2 Pages

    Purpose The purpose of this policy is to define standards for connecting to Richman Investments network from any host. These standards are designed to minimize the potential exposure to Richman Investments from damages which may result from unauthorized use of Richman Investments resources. Damages include the loss of sensitive or company confidential data, intellectual property, damage to public image, damage to critical Richman Investments internal systems, etc. Scope This policy applies to…

    • 479 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Unit 3 Assignment 1

    • 128 Words
    • 1 Page

    Baldeo Persaud NT 1330 Unit 3 Assignment 1 Business Related Questions: Do you have a DNS Server set up with your company? If so, what kind? What is the IPv4 address range? Will both companies be under one roof or two separate locations? Tasks that would need to be done: Set up a Domain that will let the two locations connect to the same information. Make sure both locations have same kind of DNS Server running. (If an older version is running on one: update and connect server to communicate with…

    • 128 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Unit 3 Assignment 1

    • 383 Words
    • 2 Pages

    Unit 3 Assignment 1 Christopher Bronson ITT San Diego Video Clip 1.07 – Ports and Connectors This video clip described the various external ports found on a motherboard. Serial Ports – 9 and 25 pin connectors (mouse, etc) Parallel Ports – 25 pin connectors (printers) Game Ports – 15 pin (joysticks, etc) PS/2 Ports – keyboards, mice Network Identification Card (NIC) – RJ-45 (connects to network) Modem – RJ-11 (phoneline connection to BBS, internet, etc) Video Connectors – Video Graphics Adapter (VGA)…

    • 383 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 3 Assignment 1

    • 310 Words
    • 1 Page

    Baldeo Persaud NT 1230 Unit 3 Assignment 1 IPv6 Addressing 1. Research the following organizations and explain their involvement with the Internet public IP addresses a. American Registry for Internet Numbers (ARIN): ARIN manages the distribution of Internet number resources, including IPv4 and IPv6 address space and AS numbers. b. Internet Assigned Numbers Authority (IANA): is a department of ICANN, a nonprofit private American corporation, which oversees global IP address allocation, autonomous…

    • 310 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Unit 3 Assignment 1

    • 260 Words
    • 1 Page

    Unit 3 Assignment 1: Disorders and Diseases Affecting the Lymphatic System Hodgkin Disease Hodgkin disease is a type of lymphoma. Lymphoma is a cancer of a part of the immune system called the lymph system. The first sign of Hodgkin disease is often an enlarged lymph node. The exact cause is unknown. Hodgkin disease is rare. Treatment often includes radiation therapy or chemotherapy. The earlier the disease is diagnosed, the more effective the treatment. In most cases, Hodgkin disease can…

    • 260 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Unit 3 - Assignment 1

    • 498 Words
    • 2 Pages

    TASK DESCRIPTION 1. Using the resources available to you, find a suitable job that you can apply for once you have completed your HND/HNC and produce the following: a. A copy of the job specification; b. A copy of the personal criteria; c. A relevant CV; (2.1) d. A covering letter (2.1) 2. Justify why the job is suitable for you and what interested you in this job. (1.1) 3. Identify any skills and/or competencies which you will need to develop in order to progress…

    • 498 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Unit 3 Assignment 1

    • 375 Words
    • 2 Pages

    1. Research the following organizations and explain their involvement with the Internet public IP addresses: a. American Registry for Internet Numbers (ARIN) ARIN is one of the five regional internet registries (RIR) that handle IP address allocation. ARIN handles the following regions, United States, Canada, parts of the Caribbean and Antarctica. ARIN manages the distribution of Internet number resources, including IPv4 and IPv6 address space and AS numbers. b. Internet Assigned Numbers Authority…

    • 375 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    unit 3 assignment 1

    • 269 Words
    • 2 Pages

    1. What does RAID stand for? A Redundant array of independent disks uses two or more drives in combination to create a fault-tolerant system that protects against physical hard drive failure and increase hard drive performance. 2. When would we use RAID? A RAID can be accomplished with either hardware or software and is usually used with network servers. 3. Define the following types of RAID: a.) RAID 0 stripes data across all drives. b.) RAID 1 is sometimes known as disk mirroring. Disk…

    • 269 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Morgan Trahan 10/02/2014 Unit 3 Assignment 1 Lymphatic filariasis is an extremely painful infection of the lymphatic system. It is caused when thread-like filarial parasites are transmitted to humans through mosquitoes. There are three forms of the parasites which are Wuchereria bancrofti, Brugia malayi and Brugia timorican. The most common is Wuchereia bancrofti. When the mosquito bites the human, it injects the larvae into the blood stream which then circulates into the lymphatic system. The…

    • 438 Words
    • 2 Pages
    Satisfactory Essays