You have been commissioned to create a database for the Great Southern Research Institute (GSRI), who runs a research centre in Sydney. GSRI conducts medical research projects for many different clients in industry and government.
GSRI staff members undertake projects for clients. Each project incurs expenses, and each project has income, which are payments that may come from clients, government or from donations. Each project has associated documents, which are of different types, for example research papers, project proposals, interim reports and others.
The following business rules and information gathered about the current business activities will allow you to derive entities. Your submission is not expected to have many to many relationships left unresolved. You may add entities or attributes as you see fit. Assumptions can be made to include further entities and their relationships, but referential integrity and normalisation processes must be adhered to. Reasons should be given for any relation that is not maintained in 3NF.
* GSRI employs many staff members, keeping track of their unique ID, first name, last name, phone number, address and email, as well as tax number, job title and weekly rate of pay.
* GSRI’s clients have a unique ID, name, address, phone, email and contact name (this is needed if the client is a company), and belong to a client type.
* Client types have a name and description.
* Projects have a unique ID, name, description, start and end dates, progress (showing % completion) and a total project Value. Additionally, each project has a project team leader, whose name and email is recorded. The project lead may not be a GSRI staff member, so we do not need to record the staff ID.
* Each project has one or more expenses, which are recorded with the amount, date, Payee and a description of the expense.
* GSRI uses several different document types, which have a name and a description.
* Each project has one or more documents. Each document belongs to a document type, has a unique ID, name (the document title) and the author’s name. Some documents reference another document (for example, a project final report might refer to a project proposal).
* GSRI receives payments for projects, where each project can receive many different payments. For each payment, GSRI has to record the amount and date paid. Depending on the payment source, specific details are recorded, as specified below:
* If the payment is from a client, then the client’s ID is recorded as well as the reference number (alphanumerical) supplied by the client.
* If the payment is from a government grant or contract, the name of the government department and the government contract number are recorded.
* If the payment is a donation, then the donor’s name, address and email are recorded.
* Each project has one or more clients, and each client can be part of many projects. Sometimes, clients are added to an existing project, or cease to be involved in a project, so for each client participation in a project, the start and end dates are recorded. Notes can also be recorded.
* One or more staff members are allocated to a project, and a staff member may work on one or more projects in different roles. A staff member may work on a project for the whole duration or part of it, therefore the start and end date for a staff member’s participation in a project is recorded, and notes.
Your submission should include:
An ER Diagram with all entity names, attribute names, primary and foreign keys, relationships, cardinality and participation indicated. All many to many relationships should be resolved.
* A list of assumptions underlying your ER diagram.
* A discussion of normalisation including the normal form that each entity is in and why that is optimal. Also a discussion of how normalisation was achieved for that entity.
* A list of relationships with all table names, attributes, primary and foreign keys indicated as per the conventions given in the lecture slides (i.e. entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics.)
* A database schema indicating the type and purpose of all attributes, and any restrictions or validation to apply.
The assignment is to be submitted via the Assignment 1 submission box in Moodle. This is to be found in the Assessments section of the course Moodle shell.
Assessment Criteria and Marking Overview Tasks Marks
• Cover page indicating student name and number and tutor name. 2
• Page numbers included in report 2
• Index giving page numbers of various sections 2
• Overall presentation of the report 2
• Full APA referencing of all materials used and full disclosure of assistance from all sources including tutors and other students. 2 10
2. E-R diagram
• Completeness of diagram 12
• Correct notation and convention used 8
• All assumptions clearly noted 8
• Primary and foreign keys 10
• Resolution of many to many relationships 12 50
• All entities and relationship in appropriate normal form 10
• Discussion of normalisation for all entities and relationships 5
• Appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal. 5 20
4. Conversion of E-R diagram to relational schema
• Correct standards, conventions and notation used 2
• Primary keys used 2
• Foreign keys correctly identified including parent entity 6
• Schema is a correct translation of the E-R diagram submitted with appropriate tables, columns, primary keys, and foreign keys. 6
• Types and restrictions on attributes given 4 20
ITEC 1006 DBMS (Database Management system) Database assignment help
The specifications for this project involve the creation of database for GSRI (Great Southern Research Institute), which is running a research center in Sydney, Australia. The project has to be submitted through the assignment one submission box in MOODLE.
We provide best academic guidance and support to learners at rates which can be easily afforded.
The database management system is actually the software applications which are interacting with various other applications for storing, retrieving and also processing data. With our academic hep services, the students can solve all their problems which they face while completing their DBMS projects. Our online assignment assistance company provides the top class ITEC 1006 DBMS (Database Management system) Database assignment help to the learners who are studying in various colleges and universities worldwide. We provide best academic guidance and support to the learners at rates which can be easily afforded. The learners can also gain the free of cost access to the solved sample papers which are already uploaded on the website.
Our customer support representatives are active 24*7. The students can talk directly to our team members at any time they want. With so many innovative features, it is extremely difficult to resist our specialized homework help services. Visit our website and place your order today.