Reference no: EM131359996
Instructions from the Professor:
Using Visio draw the ERD for your project, discuss whether it is in 3NF and why, create an SQL Database and insert at least 5 records in each table. Create 5-7 queries to retrieve data that would be useful. Your documentation for the project should include: the project description, the ERD, any business rules, the normalization discussion, the questions that your queries answer.
Details on the project I decided to make my ERD with:
I would like to create a database tracking the different types of chores that parents assign to the children throughout the week. Parents would track the daily types of chores each child is responsible for. I assigned my children a list of chores for daily check-off. Some chores are given to one child to accomplish that day while others are assigned to the other child.
Example: On Monday my son takes the trash out, sweeps the floor, takes care of the dishes, and folds clothes while my daughter vacuums the carpet, mops the floors, and takes care of laundry making sure clothes get washed and dries and makes sure the folded and hung clothes end up in dressers, drawers, or closet accordingly.
|
Can comptac bring the suit in a federal court
: CompTac, Inc., which is headquartered in San Francisco, California, is one of the leading software manufacturers in the United States. Jurisdiction. CompTac routinely purchases some of the materials necessary to produce its computer games from a New ..
|
|
How do you understand achilleus response to the embassy
: How do you understand Achilleus response to the embassy? What does this response indicate about Achilleus?what does it indicate about his relationship to the Greek army?
|
|
Conflict between agamemnon and achilleus
: Is the conflict between Agamemnon and Achilleus is ever truly resolved if it is how? If it is not why not?
|
|
Analyze financial report-communicate financial information
: Assessing ability of how you can analyze a financial report and communicate financial information in writing. In the below information you will find the monthly financial report for the reporting period ending Oct 31, 2016. Identify any recommendatio..
|
|
Create an sql database and insert
: Using Visio draw the ERD for your project, discuss whether it is in 3NF and why, create an SQL Database and insert at least 5 records in each table. Create 5-7 queries to retrieve data that would be useful. Your documentation for the project shoul..
|
|
Firm in terms of profit-employment and production
: Based on the economic indicators of Apple Inc. current standing, what are your forecasts for your firm in terms of profit, employment, and production?
|
|
What are complex programmable logic devices
: What are complex programmable logic devices (CPLDs)? Briefly outline salient features of these devices and application areas where these devices fit the best.
|
|
Labor relations-management practices-government legislation
: Human Resource Management which include staffing, training and development, motivation, and maintenance or, on any of the external factors - Labor Relations, Management Practices, Government Legislation, and Globalization that influence the proce..
|
|
What is the net advantage to leasing
: Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the informati..
|