Database programming-1

project overview

part (A)

Identification of major implementation flaws in the existing system, and/or areas

for improvement, including (but not limited to)

o Removing repeated data,

o De-normalization for optimization

o changing some areas to NoSQL (if so include what type of NoSQL


o Rational for the creation of each specific constraint (Foreign Key and

Unique) and/or index.

- Identification of the current Normal Form of the system.

- An ER Diagram for the current design of the system, and an ER Diagram for the redesigned


Part (B)

ALTER/CREATE TABLE statements for

• Changes proposed in your redesign from Part A

• Commands for the missing FOREIGN KEYs, INDEXes and UNIQUEness



• New Carer report: The hospital now wants to know

which animals are with or recently returned from Carers.

For every animal is should show their Accession ID, Name,

Species and Taxon, and the Carer’s name, Group name and

Permit number. Additionally

• For animals still with a carer: it should show when they

were transferred to the carer and total time with the

carer to date

• For animals that returned to the hospital in the last 7

days: the date returned and the total time with carer.

• New Carer Group report: List all Carer groups with

expired or soon to expire (in the next month) permits, order the

list by most expired/soonest to expire to furthest to expire. The

report should list the Care Groups name, permit number, permit

expiry date, and contact name and contact phone number

o Calling, and outputting as a single HTML page for each of the procedures:

• Carers report

• Carer Group Report

o Each procedures result should be included as a table

• For the carers report: rows with animals outside the hospital should be

pale pink, rows with animals returned should be pale green.

• For the carer groups report the rows that are expired should be RED,

rows expiring in the next week should be coloured light pink, all other

rows should not be coloured.

Kemahiran: Pengaturcaraan Pangkalan Data, Python, SQL

Lihat lagi: java list days date range calendar, company name list, vbnet service layer database layer vbnet project, database programming tutorial, database programming languages, database programming examples, khan academy coding games, what is database programming, database programming pdf, database tutorial, database programming book, banking system database system vbnet project, java project linked list assignemnt solution, form database programming, excel project task list, develop project bid list, database programming game, programming sudoku project, flash usa schools database programming project, database programming project

Tentang Majikan:
( 7 ulasan ) sydney, Australia

ID Projek: #17881022

15 pekerja bebas membida secara purata $229 untuk pekerjaan ini


Hello, Hope you are doing well. I can help with your project Database programming-1. I can assure you the quality job. I have good experience in Database Programming, Python, SQL. We have worked on several sim Lagi

$400 AUD dalam 10 hari
(26 Ulasan)

Hello, I am ready to discuss project with you. Being experienced in working on several database related projects of various complexities and designing ERD diagram etc., based on which I can help you out in getting Lagi

$100 AUD dalam 4 hari
(61 Ulasan)

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 7+ years in web designing & development with good experience in following skills Lagi

$500 AUD dalam 10 hari
(5 Ulasan)

Hello I can do it with my rich experience. Let's have a talk for more detail Thanks .............................................

$333 AUD dalam 10 hari
(7 Ulasan)

Feel fee to contact me for Database [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after Lagi

$110 AUD dalam 3 hari
(10 Ulasan)

Hi, More than a decade I am developing and delivering applications on various technologies like Java, PHP and Android. I am expert on different databases like MYSQL Oracle, Postgres and MongoDB. Please come for chat a Lagi

$150 AUD dalam 3 hari
(2 Ulasan)

i have 5 years of database development experience. i can help you to build the solution. Let's discuss the requirement.!

$110 AUD dalam 10 hari
(0 Ulasan)

Hello, I'm a web and desktop and database developer with 8 years of experience in this industry, I read your project description and attached files. I can do what you want just get in touch with me and we can discuss Lagi

$72 AUD dalam 10 hari
(0 Ulasan)

Hi sir, I am Data analyst here is my upwork account: [login to view URL]~01b468af101b75848d I read the description and downloaded the SQL file and i am totally know what you want i am ready to start Lagi

$77 AUD dalam 3 hari
(0 Ulasan)
$77 AUD dalam 5 hari
(0 Ulasan)
$70 AUD dalam 8 hari
(0 Ulasan)

Sir, I am new to Freelancer but I have huge professional experience My Brief intro is: 12+ years of System Analysis/ Design, Coding, Development, PL-SQL, ETL, ODI, Oracle Forms & Reports. Strong Hands on Oracl Lagi

$400 AUD dalam 5 hari
(0 Ulasan)

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Lagi

$100 AUD dalam 10 hari
(0 Ulasan)
$277 AUD dalam 10 hari
(0 Ulasan)

After graduating from Computer Science and Mathematical Engineering with ranked 1st, I worked on many projects in a few different companies serving in the field of e-commerce, shipment and payment systems. In most of t Lagi

$666 AUD dalam 7 hari
(0 Ulasan)