Question: Question no 01: Create a database using SQL with the following instructions. Note: Please make sure that all the points/rules must be implemented. Choose your

Question no 01:

Create a database using SQL with the following instructions.

Note: Please make sure that all the points/rules must be implemented.

  • Choose your own real time database scenario

Example:

  1. Online payment system
  2. Online ticket system
  3. Travel agency
  4. Online food delivery service
  5. Banking system

Requirements:

  1. ER Diagram of system implemented in tool such as Draw.io & DIA (Available online). (10 Marks)
  2. Create all tables presented in ERD). (5 Marks)
  3. INSERT data into tables). (5 Marks)
  4. Make ER relationships using joins. (5 Marks)
  5. Also make sure to have the primary keys and foreign keys clearly defined.
  6. System must perform all operations such as searching of particular data, insert of new record, delete, and up date.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Business rules and requirements: Aotearoa Helpers is a nonprofit organization that provides aid to people after natural disasters. They mainly work with volunteers to provide their services. The...

Q:

here is what my assignment 1 looks like with dummy data Purpose: To demonstrate the ability to identify functional dependencies and anomalies, and to apply normalization priniciples to nonrelational...

Q:

here is my dummy data from my assignment 1 Purpose: To demonstrate the ability to identify functional dependencies and anomalies, and to apply normalization priniciples to nonrelational tables...

Q:

Create and submit a sql script to answer all the questions. Make sure to add comments in the document to add title for each question. Use Chapter 8 database script to create your database that you...

Q:

the concept of minimum cardinality, or the minimum number of entities required in any given relationship is a difficult concept to grasp. Let me try to walk through an example that I hope will help....

Q:

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

Q:

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Q:

For this lab you will continue using your current project folder created for labs 2 & 3 and create 3 newsource files. Files are as follows: I already have the other files just need help with the...

Q:

Table of Contents Main Objective of the assessment 1 Description of the Assessment 1 Learning Outcomes and Marking Criteria. 4 Format of the Assessment 6 Submission Instructions. 7 Avoiding...

Q:

JBR-07575; No of Pages 12 Journal of Business Research xxx (2012) xxx-xxx Contents lists available at SciVerse ScienceDirect Journal of Business Research Organizational innovation as an enabler of...

Q:

Repeat Problem 76 is Barry is driving (a) Uphill on a road inclined at 10o with the horizontal or (b) Downhill on a road inclined at 10o with the horizontal.

Q:

Roseman resigned from the John Hancock Insurance Company following allegations of misuse of his expense account. He reimbursed the account. Subsequently he was denied employment by another insurance...

Q:

an important fact related to accual accounting is that: select one: a- expense are recorded when incurred b- revenue is recorded when cash is received c- adjusting entries are not required d- revenue...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

What combination of Key Fields in a Salary Structure Table allows for storage of historical Pay Grade Data for multiple Occupation Group Pay Grade Structures?

Q:

Explain the function and purpose of the Job Level Table.

Q:

What are Compa-Ratios? Explain the difference between Internal and External (Market Based) Compa-Ratios.