fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

5 Pages
Business Relationship Model

1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an​ ​initial conceptual​ ​model​ (Entity Relationship Diagram) for Run Monash (RM). For ...

Type

Programming

Subject

Database

3 Pages
Business Management

Sub-Task 1.1  Draw a UML domain model class diagram for the system as described here. Be as specific and accurate as possible, given the information provided. If needed information is not given, ...

Type

Programming

Subject

Database

24 Pages
BUS117-Information Systems for Business

Part 1 Design of Database You are required to design and create the following FOUR tables using Microsoft Access. (a) Customer Profile Table with relevant fields for capturing information relat ...

Course

BUS117

Type

Programming

Subject

Database

University

Singapore Institute of Management

21 Pages
MIS602 Data Modelling and Database Design

Question: Context: The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in ...

Course

MIS602

Type

Programming

Subject

Database

University

Laureate International Universities

NIT1201 Introduction to Database Systems

Question

Answered

Your task

You have been commissioned to develop a database system that is capable of keeping records for FU’s table tennis matches from now on.

The database needs to keep a record of:

• All team information, including players’ information
• All games, sections, the players involved and the scores
• The winner team of each game
• The teams play in each round
• The match winner team
• The ranking of the teams of each year’s match
• The referee assigned for each game and their performance score Further, it should be possible to generate a report on:
• Game scores after each round, including section scores
• The total number of games that each team played in a match
• The total scores of each team after a match
• The ranking list of teams after a match
• The winner list of all recorded matches
• Referees ranking, referee with best performance at all matches

Steps you need to take to develop your database application

1. Complete the analysis and design of your database application

a. List the business rules for your system.
b. Identify the entities and relationships in your system.
c. Identify the characteristics of the entities in your system. d. Develop an ER diagram to model your system.
e. Develop table structures from the ER model.
f. Conduct a dependency analysis of the table structures and normalize your tables where appropriate, to at least 3NF.
g. Create a data dictionary for your database.

2. Implement your project

a. Create a database that hosts your application data
b. Create tables in your database. These must be consistent with your design. c. Populate all tables with sample data
d. Create the required views, stored procedures etc. to meet the requirements of your system

3. to write SQL commands

1. SQL codes are provided for database and table creation
2. SQL codes are provided for data record insertion Reports by SQL:
3. to show the winner of each game in each round
4. to sort all teams according to their scores (ascending)
5. to provide a report for a referee with all the games he served
6. to provide a list of the loser teams
7. to provide a list of all players in all teams
8. Game scores after each round, including section scores
9. The total number of games that each team played in a match
10. The total scores of each team after a match
11. The winner list of all recorded matches
12. Referees ranking, referee with best performance at all matches
You need to be able to demonstrate that your database application meets the requirements detailed in the scenario as well as be consistent with the model you have developed.

Submission Requirements

Your assignment should be composed of the following parts:

1. Project document which includes the following:
1.1. A list of the business rules;
1.2. ER Diagram(s) prepared using software such as MS Office Visio or any other ER diagram tool. These should include all necessary information about the entities, attributes and relationships. Please provide clear and easy-to-read screenshot of your ER Diagram(s). If you draw your diagram(s) in MS Visio, please submit the Visio file too;
1.3. Data dictionary in the format shown in the lecture notes;
1.4. Database design and table structures showing table names, as well as any related entity integrity and referential integrity constraints. Include in the table structures attribute data types, sizes, primary keys, foreign keys and any other relevant information;
1.5. Diagrams showing the dependency analysis for each of the tables. You need to demonstrate that all tables are in 3NF. Show the process of normalization including tables in 1NF, 2NF and 3NF respectively. Please refer to the examples in lecture notes;
1.6. The SQL code you used to:
1.6.1. Create and populate the database;
1.6.2. Create each of the reports identified in the assignment specification.
2. Database implementation in XAMPP
2.1. All the tables of your assignment must be implemented in XAMPP. Please provide
screenshots as evidence of your implementation.
2.2. All the tables must be well defined with appropriate primary keys and foreign keys where
applicable. Please provide screenshot of table structures.
2.3. All tables must be populated with sample data (at least 10 entity instances – rows – in each table). Please provide screenshots of table data records.

NIT1201 Introduction to Database Systems

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

20 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has achieved the status of the best essay writing service because of an unbreakable record of delivering high-class service. Our efficient team of essay writers are based in different countries including the USA, UK and Australia. We have build teams of native essay writers to deliver country-specific, universities' requirement based custom essay help. Other than making sure that students get customised solutions. We deliver requirement based solutions and ensure that the price remains reasonable so that students can readily access our services. Because of our flexible approach, students who search the internet with search terms like write my essay at a cheap rate, find our service most in sync with their demands.

More NIT1201 NIT1201 Introduction to Database Systems: Questions & Answers

Q

Business Relationship Model

1. Using LucidChart, prior to completing task 2 (the normalisation), prepare an​ ​initial conceptual​ ​model​ (Entity Relationship Diagram) for Run Monash (RM). For this initial conceptual model, only include what you see as identifiers (keys) for each entity, do n ...

View Answer
Q

Business Management

Sub-Task 1.1  Draw a UML domain model class diagram for the system as described here. Be as specific and accurate as possible, given the information provided. If needed information is not given, make realistic assumptions. Sub-Task 1.2  Consider that a vehicle goes through many states and ...

View Answer
Q
icon

We aren't endorsed by this University

BUS117-Information Systems for Business

Part 1 Design of Database You are required to design and create the following FOUR tables using Microsoft Access. (a) Customer Profile Table with relevant fields for capturing information related to the customers such as Customer ID, Customer Name, Customers’ Address, Phone number, Paym ...

View Answer
Q
icon

We aren't endorsed by this University

MIS602 Data Modelling and Database Design

Question: Context: The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system a ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Jerry Catania

MSc in Economics

177 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Colleen Hamilton

Master Of Chemistry with Specialization in Clinical Biochemistry

2409 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Jane Mac

I am a professor of social science in the University of Southern California.

450 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Stella O'Connell

PhD in Economics

3077 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
26 Jan 2022

Economics

Course Work: 4 Pages, Deadline: 6 days

Thank you for the constant support and understanding and work towards my project

flag User ID: 8***56 Canada

student rating student rating student rating student rating student rating
26 Jan 2022

English

Essay: 8 Pages, Deadline: 10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G ...

flag User ID: 3***04 Melbourne, Bahrain

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Programming: 2 Pages, Deadline: 23 hours

Good not bad. But if the solution with more analysis and explanation will be great

flag User ID: 8***49 Melbourne, Saudi Arabia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Assignment: 6 Pages, Deadline: 5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel ...

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Chemistry

Assignment: 1 Page, Deadline: 5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

flag User ID: 2***50 Kitchener, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Psychology

Assignment: 4 Pages, Deadline: 1 day

It was a good one thank you. I did have to correct some of the mistakes. After that, everything was good.

flag User ID: 6***66 Kitchener, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Statistics

Programming: 2.6 Pages, Deadline: 7 days

Fully trust this service with perfect score. Would recommend to friends and family. Keep up the good work. Will definitely use the service.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Essay: 6 Pages, Deadline: 2 days

Perfect score. Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Criminal Law

Thesis: 8 Pages, Deadline: 4 days

Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Nursing

Home Work: 1 Page, Deadline: 12 hours

Satisfied with the assignment solution. All is correct, no amendment needed.Thanks

flag User ID: 6***60 Hughesdale, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Geography

Course Work: 5 Pages, Deadline: 6 days

Fast and prompt assignment writing services. The writer was knowledgeable in the particular subject/topics. Will engage them again for future assignme ...

flag User ID: 5***78 Hughesdale, Singapore

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Assignment: 1 Page, Deadline: 1 day

I manage to add some good point from this presentation to my assignment so thank you so much for your help I\'m awaiting marks at the moment

flag User ID: 2***49 Hughesdale, New Zealand

student rating student rating student rating student rating student rating
25 Jan 2022

HRM

Home Work: 1 Page, Deadline: 6 days

It was good work overall and I love it I will as I said always recommended people if you need help t contact them keep up the good work

flag User ID: 7***37 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

It Write Up

Programming: 4 Pages, Deadline: 4 days

Content is related to my view point and all points are well explained with the help of examples

flag User ID: 8***83 Hughesdale, Canada

student rating student rating student rating student rating student rating
24 Jan 2022

Civil Law

Essay: 2 Pages, Deadline: 18 hours

Quality work and on time. Great site when you are crunched for time. I will use it in the future.

flag User ID: 8***55 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

Networking

Case Study: 8 Pages, Deadline: 4 days

Very pleased with the time of delivery as it was delivered two days before time and also the contents of the file looked really good.

flag User ID: 5***59 Hughesdale, Australia

student rating student rating student rating student rating student rating
24 Jan 2022

HRM

Assignment: 2.6 Pages, Deadline: 3 days

The final draft collaborated with the expert and I was fairly good. I still needed to reword and switch around some stuff, but the paper structure was ...

flag User ID: 7***07 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

Finance

Home Work: 1 Page, Deadline: 13 hours

thank you for fixing my answers and doing it under the 6pm time requested. Deadline was met.

flag User ID: 8***88 Hughesdale, Australia

student rating student rating student rating student rating student rating
24 Jan 2022

Assignment

Assignment: 8 Pages, Deadline: 12 days

Decent prices, live chat is a life saving and I have received my essay on time.Bonus, the last one had a very small similarity. I would never change i ...

flag User ID: 5***94 Nuneaton, Great Britain

student rating student rating student rating student rating student rating
24 Jan 2022

Maths

Home Work: 1 Page, Deadline: 5 days

I just want to thank the person who worked on this assignment, and let them know that I appreciate the care and detail they did on this assignment. I ...

flag User ID: 4***77 Nuneaton, United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?