Lukket

I need an SQL programmer

Project Requirements:

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

follows:

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)

Færdigheder: SQL, Programmering af database, Oracle, Database Administration, MySQL

Om klienten:
( 0 bedømmelser ) Dublin, Ireland

Projekt ID: #34327206

65 freelancere byder i gennemsnit €159 timen for dette job

urmate

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 Flere

€100 EUR in 2 dage
(468 bedømmelser)
7.3
(17 bedømmelser)
6.8
divumanocha

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 Flere

€300 EUR in 5 dage
(39 bedømmelser)
6.4
(30 bedømmelser)
6.0
Truonggiang86

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 Flere

€180 EUR in 3 dage
(55 bedømmelser)
6.1
(51 bedømmelser)
5.6
digitalfog

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 Flere

€140 EUR på 1 dag
(35 bedømmelser)
5.6
(24 bedømmelser)
5.8
(31 bedømmelser)
5.3
AbdulBasitAli045

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 Flere

€100 EUR in 2 dage
(82 bedømmelser)
5.4
cccaliforniacash

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 Flere

€300 EUR in 7 dage
(5 bedømmelser)
4.9
ayesha0124

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: Flere

€250 EUR in 9 dage
(5 bedømmelser)
4.9
urmi1

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 Flere

€170 EUR in 5 dage
(18 bedømmelser)
4.8
SergeyKuznetsovv

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 Flere

€30 EUR på 1 dag
(6 bedømmelser)
4.8
(19 bedømmelser)
4.5
maverickindia

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 Flere

€230 EUR in 7 dage
(14 bedømmelser)
4.3
liveexperts123

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 Flere

€250 EUR in 6 dage
(3 bedømmelser)
4.2
TEKSCENT

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 in 7 dage
(21 bedømmelser)
4.4
mlobovic

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 Flere

€100 EUR på 1 dag
(7 bedømmelser)
4.2
(24 bedømmelser)
4.1