Ireland Assignments .ieIRELAND.ieASSIGNMENTS
Order Now Log In
  • Home
  • Services
    Writing Services
    • Essay Writing Services
    • Dissertation Writing
    • Thesis Writing Service
    • Literature Review Writing
    • Research Paper For Sale
    • Report Writing Assistance
    • Do My Assignment
    • Write My Essay
    • Buy Assignments Online
    • Irish Homework Help
    AI Support & Referencing
    • Assignment Review Service
    • AI-Free Assignment Help
    • Remove AI From Your Assignment
    • Citation and Referencing Help
    • AI Guidance for Students
    Assignment Type
    • Learner Record Writing
    • Skill Demonstration Assignments
    • Work Experience Diary
    • Reflection Journal
    • Online Exam Help
    • QQI Level 5
    • QQI Level 6
    Course
    • Nursing
    • Childcare
    • Healthcare
    • SNA (Special Needs)
    • Care of Older People
    • Child Development
    • Care Skills
    • Care Support
    • Disability Awareness
    • Infection Prevention
    • Health & Safety at Work
    Online Degree Course
    • Psychology Assignments
    • Early Childhood QQI Assignments
    • Montessori Assignments
    • Palliative Course Assignments
    • Communications FETAC Level 5 Assignments
    • Law Course Assignments
    • Management Assignments
    • Train the Trainer
    • Healthcare Assistance
    • Digital Marketing Assignment
    • QQI Assignments
    Cities
    • Dublin
    • Galway
    • Cork
    • Limerick
    • Waterford
    • Sligo
    • Dundalk
    • Carlow
    • Maynooth
  • Samples
  • Experts
  • Questions
  • Blog
  • Reviews 4.9/5
Order Now Log In
Search from Thousands of
Ireland Assignments Answers
  • 463+ Experts
  • A+ Grade
  • Free Turnitin Report
  1. Home
  2. Questions
  3. Narrative for RDBMS – database that can be deployed in a commercial database management system

Narrative for RDBMS – database that can be deployed in a commercial database management system

The aim of the project is to assess the student’s ability to design and construct a database that can be deployed in a commercial database management system.  The initial phase of the project requires the student to design a relational database for the scenario provided on Moodle.   The business rules of the scenario must be developed and implemented via the database schema and SQL as follows:

  • Relational Schema
  • Tables
  • Attributes
  • Primary Keys
  • Foreign Keys
  • Constraints
  • Primary Key
  • Range
  • Value
  • Test Data
  • Queries
  • Select
  • Insert
  • Update
  • Delete
  • Create

The second requirement of the project is to use the database created to demonstrate Codd’s rules with respect to your individual database.  The first 10 rules MUST be demonstrated using SQL including an explanation (rules 11 and 12 do not require SQL).

  • Relational Schema
  • PDF of Schematic of the database i.e. tables and relationships
  • SQL script to create the schema (CREATE COMMANDS) along with comments.
  • Test Data
  • SQL script to INSERT data along with comments.
  • Queries
  • One SQL script with each query separated along with comments.
  • Doc file with each of Codd’s Rules clearly labeled followed by the SQL code demonstrating the rule and a narrative explaining the rule.
  • Project Report: A project report (Max 2 pages) is also to be submitted, it should contain a brief explanation of all elements of the project along with any specific instructions required for the implementation of your project.

Narrative for RDBMS

Dr Mary Mulcahy runs a dental practice in a small town.  She can treat most cases, although a few specialist cases are referred to larger practices in Cork city where the required expertise and equipment are available.

Patients ask Helen, the office secretary, for appointments, either by post, phoning or dropping in.  She arranges a suitable appointment by referring to the appointments diary unless they owe over a certain amount, or for too long, as seen from the patient’s chart.  She writes the new appointment into the diary and, if it is the patient’s first visit, she makes a new chart for the patient and puts it into the charts filing cabinet.  Appointment details are also written into the patient’s chart.

Sometimes patients contact Helen to rearrange or even cancel appointments.  Re- arrangements are made by referring to the appointments diary to find a free time, and tippexing out the old time.  Cancellations are done by simply tippexing out the appointment in the diary.  The details in the patient’s chart are also updated with rearrangements and cancellations (late cancellations are charged a €10 late cancellation fee).

Every Tuesday morning, Helen checks the appointment diary and makes a list of all next week’s appointments.  She sends a reminder to all the patients (finding their addresses in their charts), enclosing an appointment card containing the appointment and treatment details with the reminders.  Next, at about 2.30 p.m. she prepares bills by searching the patient charts to find details of any unpaid treatments.  Then she looks up the Treatment Fees guidelines book, which Dr Mulcahy updates from time to time.  The bills, itemising all unpaid treatments and late cancellations, are sent to patients in the afternoon post.

Patients pay by cheque, credit card or cash, either by post or by dropping in.  The bill or the bill number is enclosed with the payment.  Treatments which have been paid for are marked as such in the patient’s file so that they will not be billed again.  Patients often arrange to make several small payments for a large bill.

When a patient arrives for an appointment, he/she presents the appointment card to Helen.  The patient sits in the waiting room until the dentist is ready to see him/ her, whereupon Helen passes the appointment card to Dr Mulcahy so that she can see what treatments are to be carried out.  After each visit, Dr Mulcahy completes the appointment card with details of work done and puts the filled card into her “Visit cards out tray”.  Helen takes the card and arranges appointments with the patient for any required follow-up treatments written on the card, and enters them into the appointments diary.  The visit card is then filed in the patient’s chart.  Sometimes patients make payments “on the spot” before leaving the clinic.

If the patient needs specialist treatment which Dr Mulcahy cannot provide, she writes the name of an appropriate specialist on the filled visit card and the secretary sends a patient referral to the specialist.  After specialist treatment, the specialist posts a dental report to Dr Mulcahy, who reads it and files it in the patient’s chart.

Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services

Get A Free Quote

Shared with
Ireland Assignments Editorial Team

A student shared this brief with our team; personal details have been removed. Our editorial team works on tasks like this and can guide you on how to approach it.

Get Help By Expert

Looking for someone to assist you with data science assignment writings in Ireland? Then irelandassignments.ie is the best solutions for the students. Our writers are skills and experienced helpers that offer a great support in masters education assignment writings.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Buy Now
Get the Answer to This Question

Tell us about your assignment in 3 quick steps and get a free, no-obligation quote.

1 Basics 2 Details 3 Contact
The basics
Over 10,000 words? Choose 10,000+ and type your exact count.
Step 1 of 3 · takes under a minute
About your assignment
What help do you need?
Do you have the brief or marking rubric?
Step 2 of 3 · last step is your contact details
Where should we send your quote?
Attach your brief, rubric or notes (optional, up to 10 files)
PDF, Word, PowerPoint, Excel or images · up to 100MB in total
Uploading…
Free quote No payment to submit 100% confidential

To Get Answer
Please Fill the following Details

If you think the question is incomplete, then you can upload your assignment brief.

Facing Issues with Assignments? Talk to Our Experts Now!Download Our App Now!

Request a Call Back
Irish assignment expert ready to help a student

Have Questions About Our Services?
Download Our App!

Get the App Today!

iphone android
QRcode
Ireland Assignments .ieIRELAND.ieASSIGNMENTS

Ireland Assignments

Ireland Assignment's offers plagiarism free assistance to the students around the globe. We understand the value of top grades to a student. And that is the reason we are here to assist you with ultimate professionalism. By availing our services we assure you better grades. Raise your academic grades with our Ireland assignment help.

Useful Links

Useful Links

Useful Links
  • Home
  • Services
  • Samples
  • Blog
  • User Reviews
  • Questions
  • Experts
  • Submit Questions
Legal & Policies

Legal & Policies

Legal & Policies
  • Privacy Policy
  • Warranty
  • Copyright Notice
  • Terms & Conditions
  • About Us
  • Contact Us
  • How Ordering Works
  • University Assignment Help
  • Final Year Project Help
  • Semester Assignment Help
  • Social Care Project Help
  • Care of the Surgical Patient
Cities

Cities

Cities
  • Dublin
  • Galway
  • Cork
  • Limerick
  • Waterford
  • Sligo
  • Dundalk
  • Carlow
  • Maynooth
GDPR
info@irelandassignments.ie
Secure Payment

77 Camden Street Lower, Dublin, D2 XE80, Ireland

Student Login·Facebook

Disclaimer: Ireland Assignments provides academic assistance to students so that they can complete their university assignments and projects on time. Our business does NOT deal with ghostwriting services as we are aware of this being one of the academic misconducts. But we do help students by connecting them to online subject experts within an affordable price range. Also, if you're looking for high-quality resources such as journals and articles, pdf files, videos, research papers, e-books, and other secondary literature to write your assignment task, then we can certainly help you out. Ireland Assignments is not sponsored or endorsed by (Ireland) Quality and Qualification Ireland or any college or university in Ireland or elsewhere in the world. All trademarks, logos and brand names are the property of their respective owners. All university related assistance services, materials and their names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Ireland Assignments rated 4.9/5 based on 15,000+ student reviews on WhatsApp

Copyright © 2026 Ireland Assignments, All Right Reserved