SQL - Creating ERD and Business Analytical Reports (queries) with Results
abc7746Create a database for an imaginary business must be normalized and populated.
Examples of imaginary business could be Pizza with Delivery, Airport, Medical Office. Don't choose a business with complicated logistics.
Your database will include an Event table (Order, Flight and Booking, Patient Appointment, Delivery, etc) with min 500 records for min 2 years or 10 months of data and 4-6 Master tables with a min of 30-50 records.
- Need ERD, 15-20 Business Analytical Reports(queries) with Results
- Research Project You may create a story, or use your work project. The project must include: ● Written story, ● Database logical and physical design ( ERD, tables) , ● Data, ● SQL Queries that represent business questions that your database would address.
- The research project can be presented as a Powerpoint, minimum of 15-20 pages long in length including ERD, CreateTable SQL, SQL Queries with returned records, Charts/Graphs and references.
5 years ago
20
Purchase the answer to view it
musicdb.txt- MusicDatabasePhysicalTable.docx
- IMG-20210814-WA0001.jpg
- musicdb2.sql
- TheMusicDatabase-2.pptx
- TheMusicDatabase-3.pptx
Purchase the answer to view it
- work 3
- BUS340
- can someone help me with history homework
- Research Paper Help
- jquery
- CJUS300 Scenario Cindy Hart is 23 years of age. She was born on 6/11/86, the fourth child born to Betty Hart (born 6/1/66) and Barney Hart (born 4/11/55). Her father, Barney Hart, was an alcoholic who drank daily and recently passed away from cirrhosis o
- WRITING ASSIGNMENT: 1. Explain what determines the level of income, employment, output and prices in our economy. 2. Do you think current monetary and fiscal policy is working to help the U.S. economy achieve the three economic goals of full employment,
- Reading
- for seanbad only
- GEOLOGY CLASS
