Reference no: EM13813732
Database and Programming Design
Need to write the items below for a Sporting Goods Ecommerce business. The assignement must be eight to ten (8-10) pages that documents the design in accordance with the attached Rubric:
a. Create a database schema that supports the company's business and processes.
b. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
c. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.
d. Normalize the database tables to third normal form (3NF).
e. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
f. Explain your rationale behind the design of your E-R Diagram.
g. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
h. Explain your rationale behind the design of your DFD.
i. Create at least two (2) sample queries that will support the organizational reporting needs.
j. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.
|
Provide stronger security
: Widgets Incorporated's computer network was recently attacked. The Chief Information Officer (CIO) wants IT to implement a log management system to allow them to monitor suspicious activities. You have been hired to implement a security plan. Discuss..
|
|
Plan and conduct an inquiry
: Plan and Conduct an Inquiry PurposeYour task is to plan and conduct a lab activity into how ONE of the following factors affect the rate of a chemical reaction: change in temperature (ex. hot vs. cold water), increased surface area (i.e. particle si..
|
|
Project quality and compliance
: Project Quality and Compliance
|
|
Upper managment in creating a diverse workplace
: How would you involve the upper managment in creating a diverse workplace? How would you incorporate your Christian Worldview into the solution to resolve the issues and correct the issues?
|
|
Database and programming design
: Database and Programming Design
|
|
Determine the amount of [h+(aq)]
: A 25.00 mL sample of 0.379 M nitric acid (HNO3(aq)) is titrated with 12.00 mL of 0.573 M lithium hydroxide (LiOH(aq)). Determine the amount of [H+(aq)] remaining in the flask and pH of the solution after reaction.(4 marks)
|
|
Health care ethics-medical law
: Imagine that you are a hospital's compliance officer, and you are charged with making a presentation to your hospital's board of directors regarding the moral right to healthcare.
|
|
Evaluate the effectiveness of officer stone efforts
: Evaluate the effectiveness of Officer Stone's efforts. Analyze and discuss a key area of strength and weakness in his approach. Identify any fundamental legal issues that Officer Stone may encounter related to how he handled this situation and his ch..
|
|
Discussions negotiable
: Discussions negotiable
|