Create a context level DFD for Pine Valley Furniture. Create a Level 0 DFD for Pine...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a context level DFD for Pine Valley Furniture. Create a Level 0 DFD for Pine Valley Furniture. Part II You may use Visio or any other suitable program of your choice to create this diagram. Building on the work you did in assignment 2 For Pine Valley Furniture. Create ER Diagrams representing the new online system. Your design should be focused on but NOT limited to the Customer, order, product, search, backorder, order status, cart and payment functions. You may use Visio or any other suitable program of your choice to create this diagram (the easy way - generate from MySQL Workbench after you have designed & built the SQL database/tables/relationships/constraints). Part III SQL Code to Implement the PVF Databases and structures Using the Pine Valley Furniture diagrams from parts I & II, create the physical databases. Create any necessary relationships and populate the tables with data. Marks will be assessed based on the tables, the datatypes selected, the relationships and constraints created as well as the sample data, and the outputs generated. To assess your code, I will run your SQL on my computer. Your SQL must be in a text file that I can run without modification. The SQL "script" you create must create everything needed for the client to use, so make sure you test it prior to submitting it. Since I am the client, I will NOT be troubleshooting your code. It either works perfectly or it does not work - Partial functionality will be considered a failure of the code to execute in the client env. If it generates errors, I will NOT work through your code to find out the reason for the errors. Your database name must be the first 4 characters of your last name plus your student ID number. e.g. kumb1234567 (no leading zeroes). Additional Detail for the SQL Component As stated above, create a text file, which will be your script with all of your SQL commands, tables, entries and data contained in it. If your E-R diagram contained entities such as Customer, Payment, Product, Search, Back Orders, Orders, Order status, Cart, then you will have to create tables that will represent those entities and also you will have to represent the relationships - being careful to sort out where you need foreign keys and so forth. So in the case of the Customer table, you will need to figure out what attributes/keys you need to include in the customer table. Consider what other tables you will need to include, such as item, cart, order, order status, etc., etc. Figure out what you need to include in each of these tables and include the relationships between these tables. Then make up some data and add these to the tables. Essentially, you are using your E-R diagram as the template for your database work using SQL in this assignment. Create a context level DFD for Pine Valley Furniture. Create a Level 0 DFD for Pine Valley Furniture. Part II You may use Visio or any other suitable program of your choice to create this diagram. Building on the work you did in assignment 2 For Pine Valley Furniture. Create ER Diagrams representing the new online system. Your design should be focused on but NOT limited to the Customer, order, product, search, backorder, order status, cart and payment functions. You may use Visio or any other suitable program of your choice to create this diagram (the easy way - generate from MySQL Workbench after you have designed & built the SQL database/tables/relationships/constraints). Part III SQL Code to Implement the PVF Databases and structures Using the Pine Valley Furniture diagrams from parts I & II, create the physical databases. Create any necessary relationships and populate the tables with data. Marks will be assessed based on the tables, the datatypes selected, the relationships and constraints created as well as the sample data, and the outputs generated. To assess your code, I will run your SQL on my computer. Your SQL must be in a text file that I can run without modification. The SQL "script" you create must create everything needed for the client to use, so make sure you test it prior to submitting it. Since I am the client, I will NOT be troubleshooting your code. It either works perfectly or it does not work - Partial functionality will be considered a failure of the code to execute in the client env. If it generates errors, I will NOT work through your code to find out the reason for the errors. Your database name must be the first 4 characters of your last name plus your student ID number. e.g. kumb1234567 (no leading zeroes). Additional Detail for the SQL Component As stated above, create a text file, which will be your script with all of your SQL commands, tables, entries and data contained in it. If your E-R diagram contained entities such as Customer, Payment, Product, Search, Back Orders, Orders, Order status, Cart, then you will have to create tables that will represent those entities and also you will have to represent the relationships - being careful to sort out where you need foreign keys and so forth. So in the case of the Customer table, you will need to figure out what attributes/keys you need to include in the customer table. Consider what other tables you will need to include, such as item, cart, order, order status, etc., etc. Figure out what you need to include in each of these tables and include the relationships between these tables. Then make up some data and add these to the tables. Essentially, you are using your E-R diagram as the template for your database work using SQL in this assignment.
Expert Answer:
Answer rating: 100% (QA)
Creating a contextlevel DFD Data Flow Diagram and a Level 0 DFD for Pine Valley Furniture involves outlining the main processes and data flows in the ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
This assignment provides you the opportunity to make a Data Flow Diagram based on a narrative. NARRATIVE: The purpose of the Give Me a Break Insurance system is to find the lowest-cost automotive...
-
4. Using Euler's method to solve following equation with time step of 1. dy = = 4t - 0.5y dt y(0)=2 You only need to write out three steps to get values of y(1), y(2), y(3). 5. Write your Euler's...
-
The November 23, 2011, edition of the Wall Street Journal Online contains an article by John Jannarone entitled "Backlash from Netflix Buybacks." Instructions Read the article and answer the...
-
(a) enables you to designate a document as a read-only file. (b) makes it possible to include a digital signature. (c) requires that you protect the document with a password. (d) requires the use of...
-
Eager Beaver, Inc., started 2011 with total assets of \($24,000\) and total liabilities of \($11,000\). At the end of 2011, the businesss total assets stood at \($34,000\), and its total liabilities...
-
In 2013, Lisa Perry opened Lisas Jeans Company, a small store that sold designer jeans in a suburban mall. Perry worked 14 hours a day and controlled all aspects of the operation. The company was...
-
On January 3, 2020, missiles launched by a U.S. drone struck a vehicle convoy leaving the Baghdad, Iraq airport and killed Iranian General Qasem Soleimani, along with 9 other people, including Iraqi...
-
Mike Curtains, a Registered Tax Agent, attends to the tax affairs of Frodo West. In preparing Frodo's 2021/22 income tax return, the following occurred: Frodo attended a meeting with Mike in August...
-
Suppose a 57.5 cm long, 8.5 cm diameter solenoid has 1000 loops.Part (a) Calculate the self- inductance of it in mH. Part (b) How much energy is stored in this inductor when 18 A of current flows...
-
A Global Positioning System (GPS) receiver is a device that lets you figure out where you are by receiving timed radio signals from satellites. It works by measuring the travel time for the signals,...
-
The relationship between inductance of moving iron ammeter, the current and the position of pointer is as follows: Reading (A) Deflection (degree) Inductance (pH) Calculate the deflecting torque and...
-
Two concentric spheres are shown in the figure. The inner sphere is a solid nonconductor and carries a charge of +5.00 C uniformly distributed over its outer surface. The outer sphere is a conducting...
-
A circular area with a radius of 7.60 cm lies in the x-y plane. part A- What is the magnitude of the magnetic flux through this circle due to a uniform magnetic field B = 0.249 T that points in the...
-
A 10 C charged object is 35 cm away from a -30 C point charge. Calculate the magnitude of the electric force between them. What is the given? What is being asked? What is the equation to be used?...
-
1- Complete the following table: 1 V 1 Determination of the power of the convex lens v (m) u (m) 1mm = (m) 4- Formula Used: (m) F (A) 0.15 0.61 2- Scale of x axis: 1 cm (in graph Paper) = Imm 3-...
-
The Cholesterol Level data sets give cholesterol levels of heart attack patients. Cholesterol measures are taken 2, 4, and 14 days aft er a patient has suffered a heart attack. Is there a significant...
-
Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The consistent mass matrix of a bar element is given by a. \(\frac{ho A l}{6}\left[\begin{array}{ll}2 & 1 \\ 1 & 2\end{array} ight]\) b. \(\frac{ho A l}{6}\left[\begin{array}{rr}2 & -1 \\ -1 &...
-
How are fixed boundary conditions incorporated in the finite element equations?
-
True or False. The system mass matrix is always singular unless the boundary conditions are incorporated.
Study smarter with the SolutionInn App