Assessment Brief: BIS1002 Data and Information Management


Assessment 2: Applied Project-1

Assessment Details:

A university college decided to create a database to schedule classes. The database business rules are:

· The database stores information about each teaching Room with the following attributes:

BuildingID, RoomID and Capacity.

· A Room can be one of two types: Lab and Classroom, and cannot be both simultaneously.

· Each Lab has an attribute LabType (Network, Web Design, Software Development etc.).

· Each Classroom has an attribute: BoardType (wall-mounted board, mobile whiteboard, glass board, chalkboard etc.)

· A Room can have none, one or several Media with the following attributes: MediaType

(projector, microphone, online media stream, printer, TV etc.).

· A Lab has computers of one or several types. A Computer has the following attributes: ComputerType (Apple, Windows PC, Linux PC, Laptop, Tablet etc.), Description, MemorySize, ProcessorSpeed.

· A Teacher has the following attributes: ID, Name, Rank and Email.

· Each Session has the following attributes: DayOfWeek, StartTime and EndTime.

· Each course Unit has the following attributes: UnitID, UnitDescription and Credits.

· A Unit might have none, one or several prerequisites.

· A Unit can have one or several classes depending on the number of students.

· A Class has attributes: ClassID and EnrollmentLimit.

· A Teacher teaches none, one or several Classes of a Unit.

· A Session is assigned to a Teacher.

· A Schedule is created for each Year and Semester. A Schedule links Sessions, Rooms and corresponding Classes.

· A Teacher uses none, one or several types of Media.

You must submit your assignment as a MS Word document. The diagrams must be drawn using app.diagrams.net online tool, saved as .png or .jpg file and inserted in the Word assignment document.

Don’t forget to include the assignment cover sheet !!!

Part 1. Conceptual Model

Please remember that the Enhanced Entity-Relationship diagram is only a part of your assignment. You need to
describe
the Conceptual Model, which must include the following elements:

· Entities and their attributes. For each entity you must also specify unique identifier attribute(s)

· Entity supertypes and subtypes. Describe inheritance types and the corresponding discriminators.

· Identify multi-valued and composite attributes (if any). In this case, they need to be shown in the ER diagram with the corresponding notations.

· Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, one-to-many, many-to-many, and also optional or mandatory

· Draw the Conceptual Model Enhanced Entity-Relationship diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document

Part 2. Logical Model

Describe the algorithm of convert the Conceptual Model into the Logical Model. Remember that your description should include the following elements:

· Entities in the Conceptual Model become relations (tables) in the Logical Model, and unique identifiers become primary keys.

· For one-to-one or one-to-many relationship between two entities you will need to create a foreign key in one of the relations (tables).

· If there is a many-to-many relationship between two entities, then you will need to create a new relation (table) with a composite primary key

· For each field (column) in a relation, describe a data type (integer, float, character, text etc.)

· If an entity contains a multi-valued attribute, then you will need to create a new relation in the Logical Model corresponding to this attribute.

· Draw the Logical Model diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document

Marking Information: The assessments will be marked out of 100 and will be weighted 30% of the total unit mark.

Marking Criteria

Not satisfactory

(0-49%) of

the criterion mark)

Satisfactory

(50-64%) of

the criterion mark

Good

(65-74%) of

the criterion mark

Very Good

(75-84%) of

the criterion mark

Excellent

(85-100%) of

the criterion mark

Demonstrate an understanding and describe the Conceptual Model design processes (25%)

Inadequate understanding and describing Conceptual Model design process

Basic knowledge only of understanding and describing Conceptual Model design process

Exhibits breadth and depth of understanding and describing Conceptual Model design process

Exhibits accurate and detailed breadth and depth of understanding and describing Conceptual Model design

process

Displays exceptional understanding of concepts and their practical application in Conceptual Model design

process

Demonstrate an understanding and describe the Logical Model design processes (25%)

Inadequate understanding and describing Logical Model design process

Basic knowledge only of understanding and describing Conceptual Model design process

Exhibits breadth and depth of understanding and describing Conceptual Model design process

Exhibits accurate and detailed breadth and depth of understanding and describing Conceptual Model design

process

Displays exceptional understanding of concepts and their practical application in Conceptual Model design

process

Demonstrate understanding and skills of creating the Conceptual Model diagram (25%)

Inadequate understanding and skills of creating the Conceptual Model diagram

Basic understanding and skills of creating the Conceptual Model diagram

Exhibits breadth and depth of understanding and skills of creating the Conceptual Model diagram

Exhibits accurate and detailed breadth and depth of understanding and skills of creating the Conceptual

Model diagram

Displays exceptional understanding and skills of creating the Conceptual Model diagram

Demonstrate understanding and skills of creating the Logical model diagram (25%)

Inadequate understanding and skills of creating the Logical Model

diagram

Basic understanding and skills of creating the Logical Model

diagram

Exhibits breadth and depth of understanding and skills of creating the

Exhibits accurate and detailed breadth and depth of understanding

and skills of

Displays exceptional understanding and skills of creating the

Logical Model diagram

creating the Logical Model

diagram

Logical Model diagram