page-header

In: database

21
Dec

CP5633 Assignment 1- Database (Conceptual) Modelling

Rationale This assignment has been designed to assess students’ ability to model a database, by constructing an entity-relationship diagram for a particular business scenario. This assignment addresses the following learning objectives for this subject:  Develop a database model using the entity-relationship model  Apply the techniques of normalisation Requirements (Tasks) 1) You are to write a brief discussion of your solution, i.e. how you approached the modeling problem and any issues you may have encountered (maximum of ½ page) 2) You are to write all applicable business rules necessary to establish entities, relationships, optionalities, connectivities, cardinalities and constraints. If a…

06
Dec

SIT103 – Database and Information Retrieval

The MediRAY chain of pharmacies has decided to develop a database system to store information of their prescriptions, patients, doctors and related details . They have given the development to your company and your manager has handed over the task to you. Below are the requirements. • Patients and doctors are persons identified by the personal identification number. The person has address, email and phone number. • Patients have patient number (the hospital and the patient number used here ), and their names, addresses, and ages must be recorded. • Doctors have doctors registration number. For each doctor, the name, specialty,…

07
Oct

COMP2400/6240 – Relational Databases

This assignment will be marked out of 10. It will count for 10% of the nal grade. Below you will nd 3 questions to reach this score. Marks are assigned for the process of nding a solution, not only for the result. Hence, include all essential ideas and steps that are necessary to derive a solution. Instructions: • This assignment should be done by a group of two students, or individually if you prefer. COMP2400 students can only be paired with other COMP2400 students. COMP6240 students can only be paired with other COMP6240 students. You can choose a dierent group partner…

07
Oct

ISYS1055/1057 Database Concepts S2/2017

ISYS1055/1057 Database Concepts S2/2017 Assignment 2 This is an individual assignment. Plagiarism in oral, written or visual presentations is the presentation of the work, idea or creation of another person, without appropriate referencing, as though it’s one’s own. Plagiarism is not acceptable and may result in charges of academic misconduct which carries a range of penalties. It is also a disciplinary offence for students to allow their work to be plagiarised by another student. For details, please check the course guide. Due time Final submission is due at 10:00pm 11 October 2017 Wednesday in Week 12. Submit one PDF file to…

26
Sep

Mysql workbench assignment

Query and update databases using SQL Task Instructions From Resources under Main Menu in Interact 2 go to Assignment 5 Folder The ‘assignment5’ database file will be made available on Interact2 Resources under Assessments folder. Use MySQL software to complete this assignment. Follow the instructions on ‘how to import a database into MySQL’: your teacher will also demonstrate this during class. Use this (imported) database ‘assignment5’ to complete your assignment using MySQL. A choice of another software may be possible after consultation with your teacher. Write SQL statements to answer the following questions from the ‘assignment5’ database file.  Show sums of…

22
Sep

ITECH 1006 – Database Management Systems

Overview For this assignment, you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with data and to run queries on the data. Timelines and Expectations Percentage Value of Task: 20% Due: Wednesday Week 11 (11:55 pm) Minimum time expectation: 20 hours Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment:  A1.design and implement a relational database using a database management system  A2.utilise a query language tools and techniques to obtain data…

16
Sep

Assignment 2: Database and Multithread Programming

Task Task 1 ( 60 marks) University grading system maintains number of tables to store, retrieve and manipulate student marks. These tables reside in a centrally or locally located server known as ‘GradeProcessing’. ‘ITC521’ is one of the tables which contains following information/attributes for all the students enrolled in ITC521: “StudentID”, “StudentName”, “Quiz”, “Assignment1”, “Assignment2”, “Assignment3”, “Exam”, “Results” and “Grade”. A sample of the table may look like as follows: StudentID StudentName Quiz Assignment1 Assignment2 Assignment3 Exam Results Grade 11111111 X 100 85 100 90 90 91.75 HD 22222222 Y 100 60 80 80 75 75.5 DI Write a JAVA…

13
Sep

Database design and Implementation

Objectives  To develop a conceptual data model diagram To perform logical design and physical design To implement a database   Introduction In this assignment, you need to create a suitable database in MS Access for the given case study.  You need to do the following: Design and draw an Entity Relationship (ER) diagram Provide answers to the given questions related to ERD Perform logical and physical design Create Database in MS-Access   Case Study CQ constructions Pty Ltd (CQC) is a successful construction company that implements many residential unit construction projects in Australia.  Each of those construction projects will have a…

08
Sep

MN405 -Data and Information Management, Managing Data in Databases

In this project you are required to design a database for managing a library database. To fulfil the design requirement you should submit the following:   Describe the project and document the following requirements:   Fully document the library database design requirement Draw the E-R Diagram Clearly set the business rules and the different type of user views Identify the different type of relationships used Clearly explain the normalisation process of the database Identify the functional dependencies in the library database Document the needed Quires, Reports and Forms used by the library                                                                                                                                             (20 Marks)   Implement the design using MS- Access…

21
Aug

MN405, Data and Information Management, Managing Data in Databases

Assignment Description 1) Below is the entity-relationship diagram for the banking database application, there are four relations/tables in their database describing banking application details, details of  projects, work assigned for each branch and account,  namely,  BRANCH, ACCOUNT, CUSTOMER and TRANSACTION.  The relationship diagram for these relations are given below.(20 Marks) 1. Write one paragraph describing the E-R diagram above in your own language 2. Implement above database on MS Access. You are required to create the above 4 tables with the given attributes. Name the database as ‘OrientalBank’. 3. Enter at least 10 data records for each table in the database…