Answer all 10 questions below:
For the following tables write the required SQL statements:
3. Write an SQL statement to create the PET table.
4. Write an SQL statement to show the breed and type of all pets.
5. Write an SQL statement to display the breed, type, and DOB of all pets having the type Dog.
6. Write an SQL statement to show the pet owner first name, last name, and pet name. Hint: you need to link PET_OWNER and PET tables.
Final exam project:
A factory has several departments. A department may have many employees but must have at least seven. Every employee works for one and only one department. Every department has a manager — only one manager per department. A manager is an employee of the company, but not all employees are managers. A department may have many machines, and every machine is assigned to a specific department. Products are produced on machines. A product can be an assembly of several different components or a single piece. Every product goes through one or more machines for appropriate production operations. Likewise, several products may go through a particular machine for a production operation. The employee has a first name, last name, and middle name, gender, address, and salary. An employee number uniquely identifies an employee. Departments have departments name, type, and location. The department’s name and number are both unique identifier of a department. Every machine will have a unique machine number, name, type, and vendor’s name.
When a machine goes for maintenance, the date of maintenance must be captured, since a maintenance activity is identified by the date of the maintenance for each machine. The attributes of maintenance activity are time taken and cost.
A product is identified by its component ID, component name, and description.
7- Create an ERD by first identifying the entities, then their relationships, and finally add the attributes to each entity.
8- Create a logical data model from ERD, including primary and foreign keys.
9- Implement the logical model into a DDL and build the database in SQL Server (or any other DBMS that you have installed)
10- Create some synthetic data and insert the data into the database.
Advantages of using our writing services
Custom Writing From Scratch
All our custom papers are written by qualified writers according to your instructions, thus evading any case of plagiarism. Our team consists of native writers from the USA, Canada, and the Uk, making it convenient for us to find the best to handle your order.
Unlimited Free Revisions
If you feel your paper didn't meet all your requirements, we won't stop till it's perfect. You're entitled to request a free revision within 7 days after we submit your paper.
Quality Writing In Any Format
If you have issues with citing sources and referencing, you need not worry. Our writers are highly knowledgeable in referencing, including APA/MLA/Havard/Chicago/Turabian and all other formatting styles.
Fast Delivery And Adherence To The Deadline
All our custom papers are delivered on time, even the most urgent. If we need more time to perfect your paper, we may contact you via email or phone regarding the deadline extension.
Originality & Security
At Master Homework, your security and privacy is our greatest concern. For this reason, we never share your personal information with third parties. We use several writing tools to ensure your paper is original and free from plagiarism.
24/7 Customer Support
Our agents are online 24 hours a day, 7 days a week, and are always ready to serve you. Feel free to contact us through email or talk to our live agents whenever you need assistance with your order.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
We work nonstop to see the best client experience.
We offer pocket-friendly prices that coincide with the preferred client's deadline.
Admission help & Client-Writer Contact
Our support team is always ready to ensure vital interaction between you and the writer whenever you need to elaborate on something.
We deliver our papers early within the stipulated deadlines. We are glad to help you if there should be an occurrence of any alterations required.
Your review, positive or negative, is of great concern to us and we take it very seriously. We are, consequently adjusting our policies to ensure the best customer/writer experience.