Data modelling and database design

University of Australia is interested in a new Student record management

system. This system needs a database to manage students enrolled, courses students

enrolled in and staff facilitating the course. You will need to store and manage the data for

the enrolled students, courses and the staff assigned to the courses. The system is intended

to be built in-house. The university has a very strong information systems suite of programs

and the students of that program are showing great insight and promise. It has signalled its

intention to seek input from those students in a consulting arrangement. The system should allow the staff to add, update and delete the records of students, staff

allocated to course and courses. In addition, University staff should be able to see the list of

students enrolled in a particular course facilitated by a particular learning facilitator.

Based on this scenario, you should identify key data objects and their attributes and define them as

columns in the spreadsheet. Create multiple versions of the spreadsheet file as per below


• Version 1 (V1.0) with all possible database objects and attributes and create 30 rows of data.

• Version 2 (V1.1) of the file should update last 2 records and add 5 additional records

• Version 3 (V1.2) of the file should add 2 new attributes

• Version 4 (V1.3) of the file should remove 5 existing attribute and add 5 more rows of data

When you are finished this, combine the four versions of the Excel database solution with a

document that in more than 1000 words, describing your experience.

Skills: Microsoft Office, Website Design

See more: database design ofbiz, database design templates, toy store database design, data modelling techniques, conceptual data model, logical data model, data modelling tools, data modelling tutorial, types of data modelling, conceptual database design, data modelling concepts, resturant database design, airline reservation database design, screen data grabber database, create database design wine shoppe company, rails data modeling data modelling database design, mysql fundamental stock data database design, database design existing data access, database design data input, database design stock data

About the Employer:
( 0 reviews ) Adelaide, Australia

Project ID: #18994903

9 freelancers are bidding on average $192 for this job


⭐Dear sir.⭐ I have read your description with great interest. I have experiences with many project. Also i am able to finish the task on time. Please check my portfolio if you want to know my skill and experience. More

$250 AUD in 3 days
(40 Reviews)

Hi, I can start work on your project immediately once you confirm me and I am also open for further discussion if you want. I have 8+ years in web design & development with good experience in following skills ... More

$200 AUD in 3 days
(31 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More

$250 AUD in 4 days
(16 Reviews)

Hi, I would like to be considered for you data entry project involving student data management. I have been working with excel professionally for over 5 years now. I have a culture for accuracy and promptness. Plea More

$70 AUD in 3 days
(0 Reviews)

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si More

$208 AUD in 7 days
(0 Reviews)

Hi there, I've read the description. Student data management system sounds great to me. I've been working with databases more than half of my IT experience, which means it's more than 6years. I'll be happy to finish th More

$222 AUD in 5 days
(0 Reviews)
$155 AUD in 3 days
(0 Reviews)

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data More

$215 AUD in 5 days
(0 Reviews)
$155 AUD in 3 days
(0 Reviews)