Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The notion style is: Tasks Task 1 (10 marks) Read the following specification of a sample database domain A university would like to computerize the

image text in transcribed

The notion style is:

image text in transcribed

Tasks Task 1 (10 marks) Read the following specification of a sample database domain A university would like to computerize the submissions of assignment prepared by the students enrolled in the university subjects. A central part of the system supposed to be a database, that contains information about the students, specifications of subjects, information about running subjects and enrolments in running subjects, specifications of assignments and assignments implemented and submitted by the students. The subjects offered by the university are described by a subject member, title, and total amount of credit points granted upon successful completion of a subject. A subject code uniquely identifies a subject. A subject title is another identifier of a subject. Subjects are delivered one time per year. A subject, that is offered now or it was delivered in the past is called a running subject. A running subject is identified by a subject code, session and year when ofered. A running subject is described by a name of lecturer and Web link to a subject outline. A student number, first name, last name, and date of birth describe a student. A student number uniquely identifies a student. The students enrol the running subjects. The database must contain information about the enrolments performed by the students in the running subjects and about the enrolment dates. A specification of assignment is described by an assignment member, release date, deadline date, and several specifications of the tasks. A subject may have several assignment specifications. An assignment number is a local identifier of assignment specification for a subject. A specification of a task is a short text. The students implement the assignments and electronically submit their implementations. Assume that an implementation of assignment is a file described by a name and type. A submission of an assignment is described by a submission date. Your task is to create a conceptual schema of the sample database domain given above and to draw such schema in a notation of UML simplified classes of objects explained to you during the lecture classes in CSIT115. No other notation will be accepted! Remember to use CSIT115-815Palette palette ! There is NO NEED to provide a detailed analysis of how a conceptual schema has been created. The final conceptual schema expressed in a notation of UML simplified classes is completely sufficient. It is not allowed to use any artificial identifiers and any attributes that are not mentioned in a specification above. attribute Class name attribute ID1 attribute ID2 attribute attribute attribute attribute attribute Related to 0..1 Related to 1..* 1 1..* Related to Related to A 1..* 1

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

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

Which of the following is equivalent to i 6 ?

Answered: 1 week ago

Question

=+j Describe an effective crisis management program.

Answered: 1 week ago