Reference no: EM133694856
Explain what your small business does, and how you will be designing a database to fulfill your requirements.
Provide the following information about your tables:
Table Name Primary Key(s) Foreign Key(s) (if applicable)
Give an example of a query you might run on your database to meet your business needs.
What criteria would you use to filter the records in your query result?
Based on the query you designed, what records would be the result of your query?
Describe the difference between a "primary key" and a "foreign key".
Introduction : You own a small business that requires you to keep information on your customers, products, orders, etc. To keep track of everything you decided to design a database to fit for your business requirements.
Instructions 1. show at least 6 tables. The tables must:
a. Represent the different entities/transactions in your business and must logically make sense based on your story described in the Assignment Form.
b. Have fields that correspond to the specific type of entity (3 of the Tables should have at least 5 fields)
c. Use at least 4 field types (Ex. Short text, number, currency, date, etc.). You should write the field type next to the field name in parentheses like so: First Name (Short Text)
d. Have at least 4 records each. Values should also match your story. Note: Use Microsoft PowerPoint to make the tables (1 on each slide) and to make the ER Diagram (1 slide). 7 Slides in total.
2. Showcase the relationships between the tables by making an Entity Relation Ship (ER) Diagram. The relationships must:
a. Have at least 4 relationships between the tables.
b. Have at least 1 many-to-many relationship.
|
Will we see even more of these attacks in the future
: the overall system is in chaos. That all being said, If hospitals can't afford to improve their security, will we see even more of these attacks in the future
|
|
Compare problem-solving process and nursing process
: Compare and contrast the problem-solving process, the nursing process, and the research process. All post must be substantive in nature.
|
|
How do type declaration statements for simple variables
: How do type declaration statements for simple variables affect the readability of a language, considering some languages do not require them
|
|
Why is it essential within the bio-pharma world
: Discuss in detail: What exactly is PDUFA? Why is it essential within the bio-pharma world?
|
|
Explain what your small business does
: Explain what your small business does, and how you will be designing a database to fulfill your requirements.
|
|
What resources-materials are needed for playing with water
: What resources or materials are needed for playing with water and toy sprinkler for babies?
|
|
Set up the server to function as a domain controller
: Set up the server to function as a domain controller. You can find guidance on this at Microsoft's TechNet.
|
|
History of smoking
: A 30 year-old patient has a history of smoking since the age of 15. The patient reports smoking an average of 15 cigarettes a day.
|
|
What we say about processes p3, p5, and p6
: Process p3 sends a message to access critical resource. It receives replies from everyone except p3, p5, and p6. What we say about processes p3, p5, and p6
|