1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
nydimaria [60]
3 years ago
11

Draw an ERD for the following problem with attributes, primary keys, cardinalities and participation constraints and specializat

ion, if appropriate.
An information studies student wants to keep track of the following information. A publishers publishes two kinds of publications: books and journals. Any one publisher publishes at least one book and/or at least one journal. Each book can be written by one or more authors and one author can write one or more books. Each book and journal is characterized by one or more indexed keywords, which are represented by a keyword number and keyword. Not every keyword is used by the journals, however. Both books and journals have a unique number (such as ISBN# for a book and ISSN# for a journal), title and a publisher. For books, the student tracks the published year, all author information and their institutions. For journals, the student keeps the starting year first published, the number of issues to be published per year and the category of the journal (such as academic, newsletter, trade). Each publisher has name, address and phone.Each author has an ID number, name, address, phone, author's affiliated institution and the address of the institution. An author may be affiliated with more than one institution.The student would like to keep only authors who are participating in writing at least one book and institutions that have such authors.
Computers and Technology
1 answer:
9966 [12]3 years ago
7 0

Answer:

Following are the solution to the given question:

Explanation:

  • Ellipses are the attributes.
  • Rectangle entities are shown.
  • Rhombus is the relationship.
  • The double rectangle is the weak entity.
  • Is-A is a triangle relationship.

There has to be N: N between books and authors because one writer can write one or more books, and one or more writers can read each book.

The N: N eigenvalues also exist among authors or students as Authors who participate in the creation of one or more books and organizations with these writers will keep their tracking of them.

You might be interested in
Match the item to the type.​
Roman55 [17]
The chart with the circle in the top right is a pie chart

the top left chart on enrollment is a histogram

the bottom chart is a bar chart
3 0
2 years ago
(Type the correct answer in the box.)
mihalych1998 [28]

1. If in MS Access, Click on Query design, select the required Table.

 In Field select required field, in this case Select [Name of Plants]. Click on Order and set it as Ascending / Descending.

2. If you want to write a Query that it will look like this

SELECT MedicinalPlants.Name of the plantsFROM MedicinalPlantsORDER BY MedicinalPlants.Name of the Plants;

Read more on Brainly.com - brainly.com/question/3433328#readmore

4 0
4 years ago
Read 2 more answers
The ip address 172.16.80.125 is written in binary notation as:
trasher [3.6K]
10101100.00101001000
8 0
4 years ago
In python, what is the difference between a dictionary and a set? How are they similar?
yuradex [85]

Answer:

"A set is an unordered collection. A dictionary is an unordered collection of data that stores data in key-value pairs."

Explanation:

Set =>

Collection of non-repetitive elements.

Unordered

Unindexed

No way to change items.

Dictionary =>

Collection of key-value pairs.

Unordered

Indexed

Mutable

4 0
2 years ago
What is a scenario where records stored in a computer frequently need to be checked
vazorg [7]

if your in  school and always are getting into trouble the school will always be checking your records


7 0
3 years ago
Read 2 more answers
Other questions:
  • Explain how can you protect your computer from malware
    15·2 answers
  • What does <3 mean at the end of a message?
    9·1 answer
  • 01010010 01100101 01100001 01101100 00100000 01101101 01110101 01110011 01101001 01100011 00100000 01110100 01101001 01101100 01
    5·2 answers
  • A chef writing up her famed recipe for beef stew realizes she has switched parsley and oregano everywhere in the recipe. The che
    13·1 answer
  • It is better to refuse to take a field sobriety test than to take a chance on being convicted of a DUI
    9·1 answer
  • Which button would you use to insert a downloaded video clip on your computer into a slide?
    15·2 answers
  • Advanced Electronics has employees who use a company website to share work. By posting on the website, employees are
    7·1 answer
  • Add the following numbers in abacus 2436+9214​
    8·1 answer
  • Which option on the Format tab is used to modify particular portions of the chart?
    13·1 answer
  • Gaining information by tricking an individual into releasing information is often referred to as.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!