E-r diagrams are oriented reward which of the data models

Assignment Help Database Management System
Reference no: EM13949415

1. Is it possible for two entities to be related to each other in two ways? For example, could entity A be related to entity B both 1:M and 1:1 at the same time?

a. No, this would violate structural integrity.

b. Yes, but this should be avoided where possible.

c. Yes, this is a perfectly acceptable practice when called for.

d. Yes, this is very desirable and should be sought after.

2. If a table is in first normal form (1NF) and has a primary key consisting of a single column, the table:

a. is at most in first normal form.

b. is also in second normal form.

c. cannot be in third normal form.

d. must be in fourth normal form.

3. Assuming common business practices, the connectivity of the relationship between publishers and books is most likely to be:

a. One-to-one.

b. One-to-many.

c. Many-to-one.

d. Many-to-many.

4. E-R Diagrams are oriented reward which of the following data models?

a. Conceptual level.

b. Internal level.

c. External level.

d. Physical level.

Reference no: EM13949415

Questions Cloud

Which coefficients are significant at the 5% level : You are comparing two cars, the first one is US-made with a 150 hp engine, which has been repaired once, and the second one is a Japanese car with a 200 hp engine, which has not been repaired. Which car do you expect to have higher MPG, and by how..
What is the direct labor quantity or efficiency variance : In 2015, Mitchell actually produced 5,000 units of product. Mitchell spent $497,250 on 25,500 pounds of DM (all of these materials were requisitioned by the production department in 2015). Mitchell spent $194,750 on 9,500 DL hours. Mitchell spent $19..
Stop the chef from working at other restaurants : If a world famous chef breaks a contract to work at a world class restaurant, should the restaurant be able to stop the chef from working at other restaurants?I only need a couple of paragraphs.  Please use legal terms
Issues facing apple really concern consumers : During audits conducted by Apple at the Foxconn plant, a number of violations were discovered. How did management/leadership at the Foxconn plant contribute to these violations? Were they preventable? How?
E-r diagrams are oriented reward which of the data models : Is it possible for two entities to be related to each other in two ways? For example, could entity A be related to entity B both 1:M and 1:1 at the same time?
Response regard to the legal ramifications of this behavior : What would your response be with regard to the legal ramifications of this behavior? What would be your response if this employee had previously been reprimanded by the organization
Reluctance of the magnetic core : Neglect fringing at the air gaps and any leakage fields. N = 1,000 turns, i = 0.2 A, lg1 = 0.02 cm, and lg2 = 0.04 cm. Assume the reluctance of the magnetic core to be negligible.
Pictures in or about the courthouse : Go inside a court house and sit in on some proceedings taking place either in a courtroom or in chambers.You may watch civil or criminal, but not traffic court. If you are in a foreign country, please ask before taking pictures in or about the courth..
Determining the d-type flip-flops : Suppose a circuit is constructed from three D-type flip-flops, with

Reviews

Write a Review

Database Management System Questions & Answers

  Creating an er model including entity classes

You will need to start by creating an ER model, including both Entity Classes and attributes. This is to be done in MySQL Workbench

  Write sql select statements to retrieve

How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent - Write SQL SELECT statements to retrieve

  Create a list of managers and supervisors

Your company wants to encourage carpooling. Create an answer table listing employee name, city and street address (in that order) for employees who live in Crestline.

  Difference between navigation mode and editing mode

In Datasheet view, what is the difference between navigation mode and editing mode? What command can you use in Datasheet view to remove the display of one or more fields from the datasheet

  Write sql statements that create tables of given information

Write SQL statements that create tables corresponding to this information so as to capture as many of the constraints as possible. If you cannot capture some constraint, explain why.

  Improve services by using database management systems

A motor vehicle maintenance center wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how can it help improve their 2.2, 3.2services

  Er diagram and database schema

To analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Create the table for the relation training courses

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  Search for a record based on a particular field value

For each of the following queries, which of the listed index choices would you choose to speed up the query? If your database system does not consider index-only plans (i.e., data records are always retrieved even if enough information is available i..

  Create a database with at least one table with ms acces

Create a database with at least one table with MS Access. Add drop-down lists (combo boxes), validation rules, and input masks as required.

  Database triggers are utilized to record logins by users

Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

  1 what is meant by data independence explain your answer2

1. what is meant by data independence? explain your answer.2. identify two benefits of separating application software

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