All categories

3 years ago

1. In the Entity-Relationship Model, relationships can have attributes. T/F

Computers and Technology

1 answer:

Anestetic [448]3 years ago

5 0

Answer:

1. True 2. True 3. Conceptual 4. 3 tables.

Explanation:

1. In the ER Model relationships can have attributes associated to them. For example in an organisation there is a one-to-one relationship between Employee and Department entities i.e. an Employee manages a Department and each Department is managed by some Employee. If you want to store the Start_Date from which the employee began to manage the department then you can give the Start_Date attribute to the relationship manages.

2. Attributes are the smallest division of data in the ER diagram. Attributes are used to describe an entity.For example an Employee entity can have the attributes Name, DateofBirth, Address, Salary. Attribute is represented by an oval with a name inside in ER diagram.

3. Conceptual

Conceptual level is the highest level ER model as it contains less but defines the overall scope of the model. It defines the data entities that are commonly used by the organization. A model on conceptual level of abstraction captures and represents business scope of the problem. It depicts the most important entities and the relationships between these entities. A conceptual ER model can be used as the base for one or more logical data models. Conceptual level describes or defines the structure of the whole database. It hides details about the physical storage and concentrates on describing entities, relationships, etc. It is part of the conceptual stage of database design and it provides a high-level data description.

4. 3 tables can be used to represent this relationship. One is a Student table. Second is the Class table. Now if we see the relationship. A student can take many classes. A class can be taken by many students. This is a many-to-many relationship between these two entities. It is not directly possible to implement this type of relationship in a database. To implement this relationship it has to be broken into 2 one to many relationships. In order to do this, a new entity has to be created. So create one more table to establish a relationship between Student and Class entities. Primary keys of Student and Class tables are added into new table to create a composite primary key. This table can be named as Enrollment. Hence 3 tables are used.

You might be interested in

Which following is one of the basic characters of object-oriented systems : Select one: a. process b. data c. module d. inherita

Leviafan [203]

The answer is D.

Inheritance means that a child class (subclass) can inherit functionality from a parent class (superclass). For example, a class called Person could have 2 subclasses called Student and Teacher. While Student and Teacher have attributes and methods that differ, they also have some that overlap. By passing these overlapping functionalities down from the Person class, we are making the code more reusable. This eliminates the need to write duplicate code and makes the code more readable.

7 0

4 years ago

Write a java code to print Multiplication Table Till 20

Ket [755]

Explanation:

Do not disturb me everyone

8 0

3 years ago

Read 2 more answers

Which threading model is best for achieving true parallelism and how?

WITCHER [35]

Answer:

The explantion of this question is given below in the explanation section.

Explanation:

Parallelism means that an application is split into smaller subtasks that can be processed in parallel on multiple CPU at the same time. Parallelism is related to application handling individual tasks on multiple CPUs. To achieve true parallelism your application must have more than one thread running, schedule the task into other threads, graphics cards, and CPU, etc.

It is noted that parallelism is a concept while multiple threading in computer programing is its implementation. Some operating systems provide a multiple threading that combined the user-level thread and kernel-level thread facility. In such a system, multiple threads within the same application can run in parallel on multiple CPU or processors

There are three types of Multithreading Model

• Many to many relationships.

• Many to one relationship.

• One to one relationship.

Many to many relationship

This model multiplexes any number of user threads onto an equal or smaller number of kernel threads. However, this model provides the best accuracy to concurrency. However, using this model, true parallelism can be achieved, if the system has multiprocessor.

Many to One model

This model maps the user-level threads to one kernel-level thread and its management is done in userspace by the thread library. In this model, only one thread can access the Kernal at a time, so multiple threads are unable to run on multiple CPU in parallel.

One to one relationship

This model provides one to one relationship between the user and kernel-level thread. This model is better than the many-to-one model. It allows another thread to execute when a thread makes a blocking system call. However, it supports multiple threads to execute in parallel on the microprocessor. This model provides true parallelism.

7 0

3 years ago

What is the best Graphics Card you can get in a Gaming Computer? Also what is the RAM do in a Comptuer

saveliy_v [14]

Answer:

For Simple AAA. title games you can get a gtx 1050 ti which can run games decent about 60 fps on med to low settings i my self am running a r7 370 and i play FiveM at 40 fps or gta5 at 60 csgo at 120 fps if you want to go higher go with the best graphics and fps go with something cheap but extreme a RTX 2070 or 2080 and with ram it help the computer run smoother basically imagin what a plate is ram so more plates you have the more food you can store in it untill someone (the computer) uses it all its a quick storage for limited time the more the better usually for gaming a 16gb should be enough

Explanation:

5 0

3 years ago

What output is produced by the following code? Integer first = new Integer(7); Integer second = first; if (first == second) Syst

fenix001 [56]

Answer:

The correct output of this question is "Sneezy Sleepy".

Explanation:

In the given code firstly we create the object of the integer class that is first in this we pass the integer value that is 7. Then we declare another second integer variable is this variable we pass object as a reference. Then we use the two conditional statements. In the first, if block we check that the object of the class is equal to the reference variable. If it is true it prints Sneezy. otherwise, it will print Grumpy. In second if block we check that the object of the class is equal to the reference variable. but in this time we the equals() function it is the same as(==). If the condition is true it prints Sleepy. otherwise, it will print Doc. So the output of the code is Sneezy Sleepy.

6 0

3 years ago