Closed

Database Systems Experts Please

This project explores the implementation of database systems through modern DBMS (DataBase Management Systems), the SQL (Structured Query Language) and database connectivity APIs (Application Programming Interfaces). The project continues by exploring the managerial considerations of large-scale database systems as well as the emergent fields of BI (Business Intelligence) and Data Analytics. This project thusly represents the logical follow-on to NQF4’s Data Modelling module.

Project Specifics:

Part 1's focus:

The ANSI-SPARC Architecture, where ANSI-SPARC stands for American National

Standards Institute, Standards Planning And Requirements Committee, is an abstract

design standard for a Database Management System (DBMS). The architecture has

three distinct layers in its description and design. Most modern commercial database

systems are based on this architecture.

Part 2's focus:

This section relates to administrating a database (you have ADMIN rights).

You are to assume the tables ‘customer’ and ‘staff’ exist within a database named

‘companydb’ and are populated with data. The users ‘smith’, ‘jones’ and ‘clear’ exist but

have no current privileges, all activities are undertaken in one ADMIN session. Issue

MySQL / MariaDB style commands

Also there is a requirement for a new database ‘rentalsdb’. Assume this is a new ADMIN

session. Issue MySQL / MariaDB style commands

Part 3's foucs:

Business intelligence (BI) is the use of computing technologies for the identification,

discovery and analysis of business data - like sales revenue, products, costs and

incomes. These technologies and functions are often referred to as information

management systems.

If you have read all the above and think you are familiar with it please state so in your opening proposal or message to me and tell me why I should work with you otherwise I will reject your proposal. Thank you

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: an expert system's ______________________ is like a database, what is database expert, database systems design implementation and management 10th edition pdf, database systems design implementation and management, database systems questions answers exams, joomla database systems, database structure army unit management system, french translation please thank, online poker database systems, core database systems forum, free developed database systems foxpro source codes, light weighed database systems, database design online leave management, please thank german english, modeling agency database systems

About the Employer:
( 3 reviews ) Manchester, United Kingdom

Project ID: #16990669

13 freelancers are bidding on average £129 for this job

fanninson45

INTRODUCTION I have 4+ years’ experience with database architecture and strategy; exhibiting excellent technical skills, and a keen sense of innovation. I am skilled in database administration and development with More

£150 GBP in 6 days
(19 Reviews)
5.6
point5nyble

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting) including ER Dimensional Modelling. Below are some key are More

£111 GBP in 3 days
(48 Reviews)
5.2
£38 GBP in 3 days
(6 Reviews)
3.3
talhamq

A proposal has not yet been provided

£55 GBP in 1 day
(8 Reviews)
3.5
Sindustrus

hi i am a recent graduate of it and totally in touch with these things please consider

£23 GBP in 1 day
(1 Review)
2.8
itinteractiveAa

hy there need database schema? oracle database model? MS SQL business intellegence tool? mysql workbench ERD? database diagram? other sql work? I'm interested to do this job. Can we discus now? Thank you

£150 GBP in 3 days
(3 Reviews)
1.3
Atkum

I have 6 year experience Freelancer,up work,Fiverr & 99design market place I have seen your project that i can to do easily because I have many experience to Graphic Design,Webdesign,Web Develop & programming .So I cou More

£150 GBP in 3 days
(0 Reviews)
0.0
sayat2002

A proposal has not yet been provided

£150 GBP in 3 days
(0 Reviews)
0.0
YuKai7777

Dear client! Great to meet you! I'm pleasured to let me introduce to you. I am web expert and I have experienced web development 5+ years. I have read your description carefully , so I think i am a fit men you want. More

£150 GBP in 3 days
(0 Reviews)
0.0
mchoudhary977upw

Professional Developer and SQL DBA with more than 4 years of experience and having skills with Oracle SQL, MS SQL server, MySQL. Along with SQL skills, experience in web development using technologies like java, pytho More

£111 GBP in 3 days
(0 Reviews)
0.0
anjanimca07

I am Oracle Database Expert with a decade of experience.I have worked on multiple complex projects and provided the solution.

£150 GBP in 3 days
(0 Reviews)
0.0
skhandhan

Data modelling with data dictionary to help in further development also a quality product will require a thoughtful time

£222 GBP in 3 days
(0 Reviews)
0.0
srinu583

Hi, The reason being you should hire me is because I have all the requirements which you are looking for... I work as an architect and good experience on ETL and Database and used multiple tools extensively and widel More

£222 GBP in 3 days
(0 Reviews)
0.0