Explain relational database and metadata

Assignment Help Database Management System
Reference no: EM13192642

1. Which is not a factor to consider in software evaluation?

A. Performance effectiveness

B. Performance efficiency

C. Target Operating System

D. Ease of use

E. Quality of documentation

2. In a database, Keys are:

 A. Normalized

 B. The names of database tables

 C. Used to identify the most important attribute of an Entity

 D. Data items in a record used to identify the record 

3. In a relational database, Metadata:

 A. Specifies the size in Bytes of the database tables

 B. Describes the name given and the length assigned each data item

 C. Describes the associative relationships between Entities

 D. Provides the answers to queries

4. Peer reviewers are the key participants in which activity?

 A. Structured walkthroughs

 B. Top-down testing

 C. Six-Sigma quality checks

 D. Rapid Application Design (RAD)

5. All of the following are true about Modular Programming except:

A. Modules should contain Go-To statements

B. Paying attention to the interfaces is important

C. Modules should be highly cohesive

D. It facilitates breaking the programming into logical, manageable portions

6. A military information system on a base overseas tracks personnel on the base. Each military member is tracked byID#, name, rank, and address. Each military member belongs to an organization on the base which has an organizationalname, located in a building on the base and has a primary function (e.g. Communications Squadron). Each of these organizations is also commanded by one of the military members . In tracking command sponsorship each militarymember may have one or more dependents. Each dependent has an ID#, name, age, and sex. Each organizationon the base is involved working issues or projects which may be of interest to the base commander. Each organization also belongs to a command which has a location and a unique numerical designation. The Organization's projects are tracked by a serial number and an origination date. The information system you are designing will also track descriptions of the projects and their close-out dates. Build an entity relationship model for the above scenario. Show all attributes and indicate all of your key attributes in red.

Reference no: EM13192642

Questions Cloud

How large is the initial spending injection : WASHINGTON-Less than one month after President Obama took office, Congress last night passed his flagship proposal, an unprecedented collection of tax cuts and new spending that Democrats say offers the country its best hope to stave off an impend..
Sketch the dual function : solve the problem and its dual, and relate the solutions to your sketch for question 1
Compute the energy of the photons : Calculate the energy of the photons and determine which principal quantum levels the transition might come from.
Which function passes the horzontal test a horzontal line : Which function passes the horzontal test a horzontal line of a parabla or a radical sign or a u line.
Explain relational database and metadata : Which is not a factor to consider in software evaluation and explain relational database and Metadata - Build an entity relationship model
Illustrate the morality of market exchange : Economists typically view free and mutually advantageous exchanges as a good thing - in the words of economists, they are "Pareto Improving." However, we may find in the literature on the "morality of market exchange".
Compute the debroglie wavelength of the emitted electron : ground state absorbs 2.50 times as much energy as the minimum required for it to escape from the atom. Calculate the deBroglie wavelength of the emitted electron
How many weigh more than 200 pounds : On Team C, 82.5% of the football players weigh more than 200 pounds. If 40 men are on the team, how many weigh more than 200 pounds?
Choose two dimensions to plug into your formula : When John, decided to renovate his garage, he also wanted to attach it to his house. The only one wall that was available to achieve this was the kitchen wall.

Reviews

Write a Review

Database Management System Questions & Answers

  Explain thoughts on database design process

Explain thoughts on database design process this far. You have learned about first three phases of process: defining mission statement and mission objectives, analyzing current database, and creating data structures.

  Systems analysis and database design

Based on the information in the Bike Mania case study, use a suitable CASE tool or drawing package to draw up a set of diagrams showing the current physical view of the systemusing the unified modeling language (UML 2.0) notation

  Create the digitalx database

Create the DigitalX database. Design tables and relationships and ensure that email addresses may only be used once in the database.

  Explain what information is available in relational database

Explain what information is available from relational database containing one relation with attributes Name, Employee identification number, and Address which is not available.

  Data analysis and definition

What is the business implications that can be drawn from the process of building and comparing these models, and has this practice helped resolve the business issue? Why or why not?

  Compute canonical cover for set of functional dependencies

Compute a canonical cover for the above set of functional dependencies (show each step of your derivation with an explanation).

  Drawing entities and relationship using crow-s foot notation

These following questions require to you to create entities and their relationship using the Crow's Foot notation suitably.

  Oracle having multiple group functions in same select list

Can Oracle have multiple group functions in the same SELECT list of query (i.e can we do a COUNT and AVG)? Let us assume we wanted to find lowest, highest, average.

  Database planner should spend a considerable amount of time

Provide what reports may be produced as a result of your database design.Based on the information you have researched, create a 2-3 page design document that includes a description of the database you would like to create as well as sample tables ..

  A county wishes to create a database

A county wishes to create a database to control its local libraries. Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employees and the general day-to-day management..

  An active database in pl-sql

Did the corresponding lines for invoices 1001 and 1008 in table LINE get deleted automatically? Can you explain why?

  Create a report which identifies five most expensive bicycle

Create a report which identifies five most expensive bicycles. The report must list bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each.

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