A) Let suppose if you are a database designer, and if you were designing a Web-based System to make Online Coffee Shop for your friend and decide to sell coffee and deliver it, which DBMS architecture and model you choose and Why? Explain your answer with the help of other models. Identify enti ties, relationships, attributes while designing the database.(There should be at least five tables or more than that). List cardinalities on both ends of each relationship (0.1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between entities)

A) Let suppose if you are a database designer, and if you were designing a Web-based System to make Online Coffee Shop for your friend and decide to sell coffee and deliver it, which DBMS architecture and model you choose and Why? Explain your answer with the help of other models. Identify enti ties, relationships, attributes while designing the database.(There should be at least five tables or more than that). List cardinalities on both ends of each relationship (0.1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between entities)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Explain the concept of denormalization and discuss situations in which it might be appropriate to denormalize a database schema. What are the trade-offs associated with denormalization?
The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 1. Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants.
When mapping entities to one another for a relational database, there are several different approaches to take. Describe your thought process when trying to determine the mapping relationship (I.e. 1:M, M:N, 1:1) of two entities.
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
Take a few minutes to examine the sample completed survey. Based on your understanding of the sample data in this file, design a database through the following process: 1- What is your database design solution in the third normal form? How does your solution meet the requirements of third normal form? Support your third normal form design with your assumptions and your understanding of the given sample data.
Design a Relational Database by Mapping the following Entity-Relationship Diagram (ERD) into Relational Model. You must clearly determine the PK of each relation. Also, you should show the links between FKs and PKs in your answer. SName Owner SHIP MOVEMENT PName HISTORY HOME PORT SHIP PORT Latitude (0,") VISITS (0.") Timestamp Longitude N N N (1.1) IN TYPE ON 1 1 Date Time StartDate VISITS Type EndDate Tonnage SHIP TYPE Name STATE/COUNTRY Name SEA/OCEAN/LAKE Hull Continent
Explain the Second Normal Form (2NF) and how it relates to the concept of partial dependencies in a relational database.
It is essential to discuss the various database table possibilities when dealing with subtype associations.Decide on a format, and then talk on the issues that should be addressed in it.
A) Let suppose if you are a database designer, and if you were designing a Web-based System to make Online Coffee Shop for your friend and decide to sell coffee and deliver it, which DBMS architecture and model you choose and Why? Explain your answer with the help of other models. Identify entities, relationships, attributes while designing the database.(There should be at least five tables or more than that). List cardinalities on both ends of each relationship (0..1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between entities)
Explain the Second Normal Form (2NF) and Third Normal Form (3NF) in database normalization. How do they build upon the principles of 1NF?