Database Design Concepts Assignment

Qualification - BTEC Higher National Diploma in Business (Computing System and Design)

Unit number and title - Unit 17 Database Design Concepts Assignment

QFC Level - Level 5

Scenario - Toy Planet

Purpose of this assignment

The toy planet database design concepts consider the skills required to perform effectively as a Database design and development employee. To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as well as the practical skills to translate that understanding into the database design and creation of complex databases.

Case Scenario
An online toy store ToyPlanet needs to have a database designed for it to be able to cater to its customers. It has approached DataSol Ltd to develop a database for the same. Davalos did requirements gathering phase and identified the following key requirements:

The system should be able to register and save details of all customers like customer name and address. Each customer is identified by a unique customer number.

Details of each toy/product will be stored in the system with a unique product number, product description and unit price in GBP.

The system should be able to take orders from the customers where each order can be tracked with a unique order number. Using that unique order number the authorized person can fetch other details of a particular order stored in the Order table like order date, order total(total amount paid in that particular order) and the customer placed that order.

Single or multiple toys can be ordered in a single order as a single or multiple order lines. Each order line can be identified using the corresponding order number and corresponding product number of the product ordered in that line The other details need to be stored in a particular order line are, order quantity and line total ( order qty/number of a particular product/toy * unit price of the product/toy ordered in that line) .

A customer can order multiple times. The same product/toy can be there in multiple orders. The unit price of a product will always be the same in all orders. Order total of the order will be the sum of all line totals in that order.

Data Sol Ltd needs to build a database for ToyPlanet based on the requirements given above.

You as an employee of DataSol Ltd are required to provide the design and implement the same design to produce a fully functional database system to help ToyPlanet carry out its tasks efficiently.


Learning outcome

AC

In this assessment you will have the opportunity to present evidence that shows you are able to:

LO1-Understand databases and data management systems  

 

1.1

 

Analyse the key issues and application of databases within organizational environments

1.2

Critically evaluate the features and advantages of database management systems.

LO2- Understand database design techniques

2.1

Analyse a database developmental methodology

2.2

Discuss entity-relationship modeling and normalization

LO3 -Be able to design, create and document databases

3.1

Apply the database developmental cycle to a given data set

3.2

Design a fully functional database (containing at least four inter-relational tables) including user interface

3.3

Evaluate the effectiveness of the database solution and suggest methods of improvement

 

3.4

Provide supporting user and technical documentation

RELATED COURSES & ASSIGNMENT SERVICE!!


COMMENTS(0)

LEAVE A COMMENT


Captcha

 

 

Are You Looking for Database Design Concepts Assignment Help?


ORDER UNIT 17 DATABASE DESIGN CONCEPTS ASSIGNMENT OF BTEC HIGHER NATIONAL DIPLOMA IN BUSINESS (COMPUTING SYSTEM AND DESIGN) & GET ASSURED A++ GRADE!

You are likely on Miracleskills right now since you are thinking whether we can provide Database Design Concepts Assessment Help to you! Well, you are in for a treat today since we sure can! It doesn't make a difference whether you need your assignments done at the present time or in a couple of hours from now. Why? Just in light of the fact that we have accessible writers day in and day out that are prepared to facilitate your scholarly loads. You should simply tap the request catch, and we will begin taking a shot at your paper. We are here to give you a magnificent administration that you will never go anyplace else. 

On the off chance that you are pondering what makes us the best and most looked for after by understudies and experts alike, read on and be stunned! We are Miracleskills, one of the best BTEC Higher National Diploma in Business (Computing System and Design) assignment composing brands that have been offering great write-ups over a wide range of subjects including Database Design Concepts. So, in case you have been searching for the same then in that case, we have the right solution for you!  

Database Design Concepts is better characterized as a lot of elements and relations as appeared in the devices with a physical or calculated presence. Database configuration is the procedure to characterize and coordinate with the device architecture. 

All unique and custom-composed: The main way we "compose assignments under Database Design Concepts Assignment Help" starts with no outside help. You can be guaranteed that every one of the thoughts, topics, and ideas that will be used in the assignment paper will be creative. Notwithstanding when your educators will run the paper through a counterfeiting programming, we can promise you that your task won't be a duplicate of someone else's work and your instructor will be very awed. 

Pick the Expert of your choice: Our faithful clients will verify the way that they can choose their favored writers. Our new customers are not abandoned either. They are likewise allowed to pick their experts under Database Design Concepts Assignment Help dependent on the Scholastic level and English capability 

All time client assistance team. We will never leave you hanging with your inquiries, requests, and different concerns under Database Design Concepts Assignment Help. You can contact us through email, and live chat. Our agents will quickly answer your prompts, with negligible holding up times. 

We deliver the content within the applicable time frame. We realize that time is of the essence; therefore, we acknowledge surge tasks and a wide range of earnestness. We have the assets and the apparatuses to guarantee that your paper will be conveyed to you under Database Design Concepts Assignment Help sooner than your mentioned due date. This is to give you adequate time to survey your paper too. 

Suitable references: The enlightening sources regarding the matters are referred to appropriately in the middle of the content, in the endnotes and commentaries, and furthermore in the book reference section. The references of the sources under the Database Design Concepts Assignment Help guarantee the analyst that the review was investigated and is unplagiarized. 

Precise and accurate assignments: In all honesty, picking a specific issue or research question is more enthusiastically than finishing the paper. This is because of the reality that there are various topics that can be examined and narrowing them into a solitary one can be very intriguing. Obviously, we as a whole realize that, when there is no theme, there will be nothing to expound on. Thusly, we are here to help you during the time spent finding the ideal postulation for your task under Database Design Concepts Assignment Help that your teacher will without a doubt affirm of. 

Moderate costs: The expense at which the client can profit our Database Design Concepts Assessment Help services isn't high in light of the fact that with the expanding requests of the scholastics we need the understudies to have master help available to them. Our costs have likewise been kept low for the clients to get in touch with us in the long periods of need without stressing over the use. Therefore, students regardless of their economic class can avail our services.