Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ER Modeling Given the following data objects ( Data entities ) and data elements ( attributes ) of a sample database. Data Object Student a

ER Modeling
Given the following data objects (Data entities) and data elements (attributes) of a sample
database.
Data Object
Student
a. identify relationship among Data Objects them.
b. Identify entity specific and common attributes from the attributes list.
c. It seems there should be more data entities and more attributes involved in this database
to make it an efficient and useful. Add necessary and sufficient data elements and data
object to this database and draw an ERD for it. Your resulting ERD should be able to hold
the answer for following queries (database questions)
i. Who are Mike Smith students in CSDA 5210 sec 01
ii. What are classes taken by Jim Meadows in fall 2020 semester
iii. What is jenny's grade in BUSS 5000?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems Xxxviii Special Issue On Database And Expert Systems Applications Lncs 11250

Authors: Abdelkader Hameurlain ,Roland Wagner ,Sven Hartmann ,Hui Ma

1st Edition

3662583836, 978-3662583838

More Books

Students also viewed these Databases questions