Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Department of Computer Science University of South Asia DATABASE MANAGEMENT SYSTEM ASSIGNMENT-01 (SPRING 2016) BSCS Semester-02 Due Date: 16-03-2016 Marks: 10 Question: # 1 A

Department of Computer Science University of South Asia DATABASE MANAGEMENT SYSTEM ASSIGNMENT-01 (SPRING 2016) BSCS Semester-02 Due Date: 16-03-2016 Marks: 10 Question: # 1 A large organization that does automobile repairs must keep track of its repair facilities or garages, the mechanics, and their qualifications in terms of the courses they have taken, the dates they took the courses, and the grade each earned for each course. Descriptions of these items are as follows: Garage: Garage's identification number and manager's name Mechanic: Employee number and name Course: Number, name, and duration (in weeks) a. What are the entities (fields) in this situation? What are the attributes of each entity? b. List the entities and their relationships to other entities or other attributes under one-to-one, one-tomany, many-to-many relationships. For example, \"garage\

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

Management Fundamentals

Authors: Robert N. Lussier

5th Edition

1111577528, 978-1111577520

More Books

Students also viewed these General Management questions