Advanced Database

The questions in it make use of three different database schemas, OrdersDB (a simplified version of the classicmodels database), StudentDB (a database tracking students, the modules they are enrolled in and their lecturers) and RentalDB (a simplified version of the sakila database introduced in the first assignment. The schmea for all three databases is attached at the end of this assignment. Primary keys are underlined, while foreign keys are italicised. Each schema also includes a list of foreign to primary key relations, as the corresponding keys are not always named the same in different tables (in the RentalDB schema, for example, the primary key staff_id in the staff table is a foreign key in the store table but is named manager_id instead).

Skills: Database Administration, Database Development, Database Programming

See more: advanced database, advanced database system, advanced access database questions, advanced database structure, query includes remote database, flex php database advanced, advanced php database, advanced database projects java

About the Employer:
( 1 review ) DUBLIN, Ireland

Project ID: #12163285

12 freelancers are bidding on average $73 for this job


Hello there, i'm expert on database technology, let me help you with this. I'm sure that i can finish 10 questions in a short time. Waiting for your feedback if interested. Thank you!!

$100 USD in 2 days
(66 Reviews)

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p More

$100 USD in 1 day
(12 Reviews)

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here h More

$100 USD in 2 days
(18 Reviews)

Sir, I can do this project .Message me to discuss. My goal is to provide quality work and best service for my clients. I will accept projects only when i'm 100% sure. Thanks! :)

$166 USD in 1 day
(9 Reviews)

Hello Sir, We thank you to give us the opportunity to bid on your project. We are really interested to work on your project. I had a look on your requirement and I think we have exact skill set to effectively complet More

$100 USD in 2 days
(1 Review)

Hello I am Software Engineer and expert in Database design and development so you can consider me for this Project Thanks I will wait for your quick Response

$25 USD in 9 days
(4 Reviews)
$70 USD in 1 day
(2 Reviews)

I am expert in SQL, Databases, DB Modeling and Analysis,Relational Algebra and Oracle Certified Professional. Can do the task as per your requirements.

$70 USD in 3 days
(4 Reviews)

Dear Sir, I have experience in data entry and other task easily and having ability to give back to you fine results. I am professional Accountant and have been working since last 10 years in Accounting Industries. I h More

$10 USD in 1 day
(0 Reviews)

I have extensive experience working with SQL Server for the past 10 years. I can write quick and efficient code using any of the SQL Versions.Can easily understand and follow the data models and relationships between t More

$25 USD in 1 day
(0 Reviews)

I have years of knowledge in relational database, Oracle certified and I was Oracle instructor in sql and pl/sql.

$88 USD in 3 days
(0 Reviews)

I can fix the issue within the timeline. and deliver with what customer expects. I do have 5+ years of experience in Oracle DBA

$25 USD in 5 days
(0 Reviews)