Assignment Task :

Scope This assignment is related to conceptual modelling of the sample database domain, extension of a given conceptual schema and logical design.

 

Tasks 1

Read and analyse the following specification of a sample database domain. A university library has a database consists information of books, journals and past exam papers. The library also provides study rooms for staff and students. A book has a unique code of catalogue number, ISBN number, title, authors’ names, a list of key words (up to 5 key words), publisher name, date of publication. A journal has a unique catalogue number, an ISSN number, title, a list of key words (up to 5 key words), chief editor name, a volume number and an issue number. ISSN number, volume number and issue number can uniquely identify a journal stored in the library. A past exam paper consist a unique code of catalogue number, subject code, year of the subject, session of the subject (can only has a value of spring, autumn or summer). Subject code, year of the subject and session of the subject can uniquely identify a past exam paper of that subject. The library makes all its information available to the university community. A staff member is allowed to borrow maximum 20 items (e.g. books, journal publications and others). A student is allowed to borrow maximum 10 items. The library keeps a record of who borrowed each item and the return date. A staff consists a staff number, name, date of birth, work phone number, home phone number (optional), level and department. A staff number can identify a staff member. A work phone number is unique for a staff member. A student has a student number, name, date of birth, home phone number (optional) and home address. A student number is unique. Name and date of birth of a student can uniquely identify a student. An objective if this task is to construct a conceptual schema for the specification of a database domain listed above. It is not allowed to add any artificial identification attributes commonly known as "id" attributes to the specification listed above. Use UMLet tool to create a drawing of a conceptual schema in a notation of UML simplified class diagrams explained to you during the lecture classes in CSIT115. No other notation will be accepted 

 

This Management Assignment has been solved by our Management Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : January 05th, 2018

Whatsapp Tap to ChatGet instant assistance