Explain how to derive new classes from base classes

Assignment Help Database Management System
Reference no: EM131142503

Part 1:

QUESTION 1
A highly organized collection of data is a database management system.
True
False

QUESTION 2
Financial data residing in a database is not a corporate resource.
True
False

QUESTION 3
Modality is the maximum number of entity occurrences involved in a relationship.
True
False

QUESTION 4
Unary relationships contain one entity type.
True
False

QUESTION 5
In a database, if there is more than one candidate key one MUST be identified as a primary key.
True
False

QUESTION 6
A concurrency problem is defined as multiple data sets stored in the database.
True
False

QUESTION 7
The most significant problem with data redundancy in a database is data integrity.
True
False

QUESTION 8
Data redundancy can result in requiring unnecessary storage space for the database.
True
False

QUESTION 9
Many-many relationships should be converted to associative entities on an Entity-Relationship diagram.
True
False

QUESTION 10
There are two modes of data access known as sequential and direct access.
True
False

QUESTION 11
Data within a database is typically controlled and manipulated by:
A. MY SQL Workbench
B. Database Management Software
C. MS Word
D. MS Excel

QUESTION 12
A unique identifier of an entity is ____
A. Relationship
B. Cardinality
C. Attribute
D. Binary

QUESTION 13
In an M-M relationship, the combination of or the association between two entities is known as ____
A. Cardinality
B. Modality
C. Associative entity
D. Intersection data

QUESTION 14
A ________ relationship associates occurrences of an entity type with other occurrences of the same entity type.
A. Binary
B. Tertiary
C. Unary
D. Secondary

QUESTION 15
How many entity types are involved in a tertiary relationship?
A. 1
B. 2
C. 3
D. 4

QUESTION 16
The means by which an analyst records, documents, and diagrams the business environment is known as ________.
A. Relationship Identification
B. Data Association
C. Data Analysis
D. Data modeling

QUESTION 17
In a DBMS, Referential Integrity contains three rules which are:
A. Restrict
B. Cascade
C. Set-to-null
D. Read
E. All of the above
F. A, B, and C

QUESTION 18
The process of arranging attributes of entities in a given business environment into database structures is known as:
A. Physical Database design
B. Database structuring
C. Logical Database design
D. Relationship mapping

QUESTION 19
Each row of a database is known as a ______
A. File
B. Field
C. Entity
D. Record

QUESTION 20
An entity's attribute in a database management system is referred to as a ________.
A. Record
B. Relationship
C. Field
D. Row

QUESTION 21
A foreign key is defined as _________.
A. The key attribute of an entity
B. An identifier of the relationship
C. Primary key of an entity
D. Primary key of a relation that appears in another relation

QUESTION 22
An attribute or field that uniquely appears in every row of the relation is known as ____.
A. Key field
B. Primary Key
C. Foreign Key
D. Intersection ID

QUESTION 23
Each table column in a database entity is commonly known as a ____________.
A. Record
B. Relationship
C. Field
D. Primary Key

QUESTION 24
The purpose of a database is to _____________.
A. Eliminate redundancy
B. Centralize data
C. Integrate data logically
D. All of the above
E. None of the above

Part 2:

QUESTION 1
Describe what is an array. Provide examples and uses in VB & C# languages.

QUESTION 2
Explain how to derive New Classes from Base Classes. Provide examples and uses in VB & C# languages.

QUESTION 3
Describe classes, including constructors, methods, data, value, and reference types. Provide examples and uses in VB & C# languages.

QUESTION 4
Describe delegate types. Provide examples and uses in VB & C# languages.

Reference no: EM131142503

Questions Cloud

Explain the ethical issues related to the supervisor : Explain the ethical issues related to the supervisor. Explain the ethical issues related to the supervisee/student. Examine the influence of your own personal values as it relates to the issues presented in the case.
Highest possible final grade in nighttime conditions : What is the highest possible final grade in nighttime conditions? (Note: Be careful of units of A, and ignore the cross-sectional width of the overpass.)
What would be the minimum bridgetunnel separation : If so, what would be the minimum bridgetunnel separation distance (something higher than the current 1200 ft separation) needed to connect the elevations of the bridge and tunnel with 70 mi/h designspeed curves?
Tips for improving your memory : Write a persuasive essay on the topic "Tips for improving your memory"
Explain how to derive new classes from base classes : Explain how to derive New Classes from Base Classes. Describe classes, including constructors, methods, data, value, and reference types. Provide examples and uses in VB & C# languages.
Explain requirements and the sequence of licensure process : Explain the requirements and the sequence of the licensure process in the state where you plan to practice. You must cite the source from where you obtain the state licensure information. ( the state I reside in is New Jersey)
Provide an appropriate vertical alignment : What length of the existing level highway must be reconstructed to provide an appropriate vertical alignment?
What is the trade-off between junk food and gasoline : Kathy, a college student, has $20 a week to spend; she spends it either on junk food at $2.50 a snack,or on gasoline at $2 per gallon
Design vertical alignment to connect between two stations : Design a vertical alignment to connect between these two stations using a 50-mi/h design speed. Provide the lengths of the curves and constant grade section.

Reviews

Write a Review

Database Management System Questions & Answers

  List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.

  Write sql statements to create the corresponding relations

Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

  Create an xml representation of data

Create an xml representation of data describing various relational database management systems (e.g. Microsoft SQL Server, MySQL, ...)

  Write a query to list the title and price of all items

Write a query to list the title and price of all items that have been ordered by customer Millerton. Write a query to list thelast name and order id of customers that ordered any items by the artist Burt Ruggles?

  Create a gis database of information about vietnam

You are asked to create a GIS database of information about Vietnam at scale of 1:100,000. Database will include the following: Which of these features are best represented by raster model? Explain why?

  Write a select statement that returns three columns

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns.

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Create stored procedure to updates members balance

Create a stored procedure that updates the members' balance in the membership table by correctly recording the current or outstanding balance for each customer.

  Convert table to first normal form

Convert this table to First Normal Form

  What are the advantages and disadvantages of each method

What are the advantages and disadvantages of each method? Are there any inherit dangers with either method

  Write one page about xml format

Write one page connecting the following issues as discussed in chapter Plumbing and XML format.

  What kind of information will be included in the database

To design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be organized. There are several approaches to creating a successful datab

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd