I need an SQL programmer

Project Requirements:

You are asked to design and implement a Database for a new University called MTUC as


MTUC has Academic staff, general staff and students who are working or attending this new

University. Each person is either academic staff, or a general staff, or a student. A person is

uniquely identified by a PerId (person's ID), and has a Name, and an Address. An Address is

composed of HouseNo, Street, and City. A characteristic property of a student is that

she/he has 1 course and 12 modules for this course in one year. An academic staff has a

Position (Head of Department, Lecturer, Assistant Lecturer) and an academic qualification.

A general staff has a job title. An academic staff teaches at most one course, whereas a

student takes at one course with many (12) modules. A course is uniquely identified by a

CourId (course ID), and has a CourName (course name). Each course is taught by at least

one academic staff, and can be taken by many students, but there may be courses that are

not taken by any students. Each course can use more than one textbook, but there may be

courses with no textbook.

Your design must enforce:

Uniqueness on important data items e.g. each Student, Staff, Course, etc

You can make any assumptions about the data that you feel are relevant.

Project Tasks and Submissions:

1. List the Entities, Attributes and Relationships and Multiplicities. (30 Marks)

2. Draw an ER Diagram using the information from step 1. This can be done using the

drawing tools in MS Word, or by drawing it by hand and taking a picture to include

within your submission. (20 Marks)

3. Implement the design from steps 1 &2 on your MySQL server. All CREATE TABLE,

DROP TABLE statements must be provided in script form (.sql file) and should be

included in your submission. You must indicate all Primary, foreign and candidate

keys. (20 Marks)

4. Devise sample data i.e. make up at least 4 rows of data for each table. Provide the

Insert statements in script form (.sql file) and should be included in your submission.

(10 Marks)

5. Write FIVE SQL multi-table JOIN queries that demonstrate the functioning of your

database design. All tables should be used in those queries - essentially you will be

expected to formulate requests that require you to write 3/4/5 table joins to

complete this part successfully. Include the queries in your MS Word/PDF Document

(20 Marks)

Навыки: SQL, Программирование баз данных, Oracle, Управление базами данных, MySQL

О клиенте:
( 0 отзыв(-а, -ов) ) Dublin, Ireland

ID проекта: #34327206

64 фрилансеров(-а) готовы выполнить эту работу в среднем за €160


Hi I have checked your project description. I have excellent programming and development skills. Contact me with all the details and requirements for your project for further discussion. I will provide you with dedica Больше

€100 EUR за 2 дней(-я)
(474 отзывов(-а))
(18 отзывов(-а))

Hello, Greetings of the day !! Yes, I am all Rounder & Full stack developer . So I completely understood your all requirement and I am well familiar with the requirements and will surely help you in all projects. I ha Больше

€300 EUR за 5 дней(-я)
(40 отзывов(-а))

Hello there, it seems you need to design the database from the beginning: draw ERD, implementation in MYSQL, insert data and write 5 queries using multiple join. I've done many project like this before. Waiting for you Больше

€180 EUR за 3 дней(-я)
(56 отзывов(-а))
(30 отзывов(-а))
(51 отзывов(-а))

Thank you very much for such a detailed description. Such a description is very rare here. I really like to build ERD and I will be glad if I can help students with my experience. The task is described more than clearl Больше

€140 EUR за 1 день
(35 отзывов(-а))
(25 отзывов(-а))
(31 отзывов(-а))

Hi, I can assure you 100% that we are fully capable of executing any level of task/project based on the skill required. I am fully confident about our skills and my understanding of the project description and we are r Больше

€300 EUR за 7 дней(-я)
(5 отзывов(-а))

Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and Больше

€100 EUR за 2 дней(-я)
(83 отзывов(-а))
(28 отзывов(-а))

Hello there, The skills Oracle, SQL, MySQL, Database Administration and Database Programming u mentioned on the project fall under my level of expertise so i can surely help u with it. Please have a look at my profile: Больше

€250 EUR за 9 дней(-я)
(5 отзывов(-а))

I did reviewed your project details . I believe that i will definitely meet your specification with my professional service. I have rich experience with HTML, Css, PHP, JS, Boostrap, woo-commerce, wordpress theme custo Больше

€170 EUR за 5 дней(-я)
(18 отзывов(-а))

Hello, Warm Greetings ! I am interested in your project. I have 5 years of experience in SQL, Oracle, MySQL, Database Administration, Database Programming. I will build the your perfect database according to your r Больше

€30 EUR за 1 день
(9 отзывов(-а))

Hello Sir, I have read your requirements carefully and got a total understanding of the project .kindly discuss your project in detail with [login to view URL] fake commitment,100% quality work. I have more than 9 years of experie Больше

€230 EUR за 7 дней(-я)
(14 отзывов(-а))

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Больше

€250 EUR за 6 дней(-я)
(3 отзывов(-а))

Hi Nice to meet you. I have read your job carefully and I'm very confident about your job. As a talented application developer, I have much experience with SQL for more than 10+ years. If you give me a chance to chat w Больше

€100 EUR за 1 день
(8 отзывов(-а))

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development, power bi and programming using python. I will be able to help you with the project. Please ping me offline Больше

€333.33 EUR за 3 дней(-я)
(11 отзывов(-а))

I have more than 13 years of experience in sql development in different database like oracle/db2/mysql and worked in more than 300 projects. Lets discuss your requirement.

€250 EUR за 7 дней(-я)
(21 отзывов(-а))