1. What is an entity super type, and why is it used? It is an entity with 1 or more subtypes. It contains common characteristics. It is used to take advantage of inheritance, constraints, discriminators, and reduce the number of nulls. 2. What kinds of data would you store in an entity subtype? Entity subtypes contain more unique characteristics. A subtype will contain that data that is specific to the entity. Ex. A super type entity named Student contains a field for degrees studying but
Words: 1326 - Pages: 6
Example Case to 3NF Tables Purpose The COIS20025 textbook and assignments have numerous exercises that require you to take a given case and generate a data design for the case. The data design will typically consist of an ERD, 3NF table designs including keys (obviously) and sample data. The purpose of this document is to give an example of how to do this. It walks you through the process of completing this task. Preparation This document draws on some existing resources including: •
Words: 1358 - Pages: 6
Part 1: Question and Answer Question 1: Difference between Indexed Table and Indexed View.. Indexes on table are generally always used. You will have at least one unique index and one of the indexes will be clustered. Indexes on views are generally only applied as an optimization technique. Indexes on the view can improve performance using the views. Question 2: Clustered VS non-clustered index Question 3: Explain HIP table A: Heap table is a table that does not have any Clustered Index. Question
Words: 1489 - Pages: 6
University of Phoenix Material Database Environment, Development Process, and Staffing Tables Part I Database Environment Table Describe each component of the database environment, and provide a common vendor-supplied example or an example of how this component relates to the rest of the database environment. |Components |Description |Example | |Database Management |The Computer Software application
Words: 1500 - Pages: 6
Data - raw facts about things and events Information - transformed data that has value for decision making 1. Persistent - data that resides on stable storage such as a magnetic disk (does not have to be forever - can be deleted or archived when no longer needed) 2. Shared - multiple uses and multiple users 3. Interrelated - data stored as separate units can be connected to provide a whole picture Database Management System - DBMS - A collection of components that supports: 1. creation
Words: 1567 - Pages: 7
Chapter 2 - Database System Concepts and Architecture Data Models, Schemas and Instances A characteristic of the database approach is that it provides a level of data abstraction, by hiding details of data storage that are not needed by most users. A data model is a collection of concepts that can be used to describe the structure of a database. The model provides the necessary means to achieve the abstraction. The structure of a database is characterized by data types, relationships
Words: 2961 - Pages: 12
must somehow attach to the vehicle and can include anything that would appeal to the target market. Equipment Engineering notebook Pencil Digital camera Graph paper All related CAD models from your reverse-engineered product CAD solid modeling software Internet access Library access Printer Product Improvement Design Brief Template Decision Matrix Template Procedure In this activity your team will identify an enhancement to the Automoblox vehicle that you have reverse-engineered
Words: 396 - Pages: 2
Here is some clarification on functional dependencies. A functional dependency - if you know X, you can reasonably assume you know Y. X->Y X determines Y. Y is dependent on X For example: In the database in the Social Security Administration, your SSN relates to your first name and last name. SSN->Name, Address For Q11, select logical fields were a functional dependency may exist and create tables In Q11, the studentnum is probably unique. 1. Determine the FDs by selecting the
Words: 286 - Pages: 2
1. Consider the relation CLASS(Course#, Univ_Section#, InstructorName, Semester, BuildingCode, Room#, TimePeriod, Weekdays, CreditHours). This represents classes taught in a university with unique Univ_Section#. Give what you think should be various candidate keys and write in your own words under what constraints each candidate key would be valid. Answer: Possible candidate keys include the following (Note: We assume that the values of the Semester attribute include the year; for example "Spring/94"
Words: 930 - Pages: 4
Entities, Attributes, Business Rules and Database Models CIS111 Deontae Gaskins Ali Rahat-Zafar Strayer University April 13, 2016 Entities, Attributes, Business Rules and Database Models A database is defined as a grouped and organized set of data held in a computer system. A college database, therefore, can be defined as a small repository for its operational data. A college can use a database to access, manage and update its functional data. Additionally, it can use the database to
Words: 799 - Pages: 4
