Create a database named Amazon using the attributes.Create individual tables based on below attributes Customers Products Product_types Orders Customer payment methods Tacking Order status Shipments Invoice create different tables and mention their primary keys and foreign keys Describe atleast 6 business rules create Entity Relationship Diagram.The ERD should be in Crow's Foot Model.It should include all the appropriate entities,connectivity,cardinalities and relationship participation. 4 sample queries in plain English and their SQL SELECT statements

Create a database named Amazon using the attributes.Create individual tables based on below attributes Customers Products Product_types Orders Customer payment methods Tacking Order status Shipments Invoice create different tables and mention their primary keys and foreign keys Describe atleast 6 business rules create Entity Relationship Diagram.The ERD should be in Crow's Foot Model.It should include all the appropriate entities,connectivity,cardinalities and relationship participation. 4 sample queries in plain English and their SQL SELECT statements

MIS

9th Edition

ISBN:9781337681919

Author:BIDGOLI

Publisher:BIDGOLI

Chapter3: Database Systems, Data Warehouses, And Data Marts

Section: Chapter Questions

Problem 4P

See similar textbooks

Similar questions

Answer for the following questions in brief?(i) What is an Entity and Attribute? Write different types of Entities and Attributes, along with their specific symbols?(ii) Discuss: Composite Primary Key, Foreign Key, Candidate Key, Unique Constraint,(iii) Draw and discuss three tiered architecture?(iv) Differentiate between Ternary relationship and three binary relationships.(v) Differentiate between conceptual and internal schema in a database design
Need this in 30 minutes please Just draw me the Entity-Relationship Digram and here is all the infomation you need for complete it Entity-Relationship Diagram (ERD) An ERD visually represents the relationships between entities in a database. Here's what you need: Entities: Product: Represents items sold by the coffee shop. Transaction: Represents a sale event. Payment: Represents the payment method used for transactions. BeanCard: Represents the loyalty or prepaid cards customers can use. Attributes: Product: Product ID, Name, Category (Beverages, Bakery goods), Price. Transaction: Transaction ID, Date, Total Amount. Payment: Payment ID, Type (Cash, Credit, BeanCard), Amount. BeanCard: Card ID, Customer ID, Balance. Relationships: Products to Transactions: A transaction can include multiple products (many-to-many). Transactions to Payment: A transaction is completed with a single payment method (one-to-one). BeanCard to Payment: A BeanCard can be used for many payments…
Make ER diagram for Movie website wants to store information about movies andhas chosen you to help them Three steps: Requirements Analysis: Discover what information needs to be stored,how the stored information will be used, etc. Taught in course on systemanalysis and design Conceptual Database Design: High level description of data to be stored(ER model) Logical Database Design: Translation of ER diagram to a relationaldatabase schema (description of tables)(Database Schema). Physical Database Design: Done by the DB system. Requirements For actors and directors, we want to store their name, a uniqueidentification number, address and birthday (why not age?) For actors, we also want to store a photograph For films, we want to store the title, year of production and type(thriller, comedy, etc.) We want to know who directed and who acted in each film. Every filmhas one director. We store the salary of each actor for each film An actor can receive an award for his part in a…
You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…
Which of the following is a key part of conceptual design in an entity relationship model? This model resolves the many-to-many relationships to multiple one-to-many relationships. This model adds all of the attributes for each entity. This model converts attributes into columns. This model does not depend on the database management software or the hardware used to implement the model.
Create an ER model related to the following entities and relationships: Department, Student, Professor, Course, Section, Grade, Major. (For attributes inside each table, you only need to insert several reasonable attributes. No need to have a comprehensive list. For many-to-many relationship, you also need to insert one extra table to handle the many-to-many relationship. The final database design will have more tables than the number of entities listed above.) A given department can offer many courses. A given course can be offered by only one related department. A given course can have many related sections. A given professor can teach many sections. A given section can only be related to one course and taught by one professor. A given professor can have appointment with different departments A given department can have many professors. A given department can offer several majors. A given major can be offered by only one related department. A given student can have several majors. A…
Use the database tables shown to answer Problems (a) to (d) below. a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. b) Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. [6 Points] c) Create the relational diagram to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC d) Create the Crow’s Foot ERD to show the relationships among EMPLOYEE, EDUCATION, and EMP_EDUC.
how can I Write the CREATE DATABASE, USE, CREATE TABLE, and DROP DATABASE Statements from its conceptual design? The relational schema is Region(RegionID, regionName, director) StateOfRegion (stateCode, stateName, statePopulation, Region ID(fk)) Store(storeID, phone, manager, address, EmpID (fk)) Employee( empID, empName, hireDate, birthDate, socSecNum, storeID (fk) ) Supplier ( supplierID, suppliername, contact, email, phone) Supplies( storeID (fk), supplierID (fk), start Date)
Using er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name Address Year of grad All Phone numbers Club name Club advisor Meeting dates
Draw an ER diagram that represents the main aspects of the Apple products database (entities, attributes, relationships, mapping cardinalities, etc.) Entity Sets: Customer Preference Apple product Store Factory Product_Item Relationships: Buys Sells Contracts Produces Has Contains Customer buys apple product Store sells apple product Factory contracts_with Store Factory produces apple product Customer has preferences Store contains product_item
For this project you will choose a business or use the previously chosen business to design a database through thestages.Your business must meet the following requirements: It must have 2 or more master or parent tables It must have 3 or more child or transaction tables The project will include the following elements for the chosen business.1. Introduction and Overview of the database2. Identify the business rules of this business as it applies to the data3. Create an Entity Relationship Diagram in crow’s feet notation.4. Create a relational diagram using a 3 column crow’s feet diagram. Make sure you include all primary and foreignkeys and data types on all columns.5. Create a table in the lab document to identify the primary key for each entity.6. Explain and apply the integrity rules for each entity.7. Use a table in the lab document to define the relationships between each entity. Make sure you list thecardinality of the relationships.8. Create the database in SQLite.9. Show SQL…
1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.)2. Design a database diagram for a database that stores information about the downloads that users make from a website.Each user must have an email address, first name, and last name.Each user can have one or more downloads.Each download must have a filename and download date/time.Each product can be related to one or more downloads.Each product must have a name.