You handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning more. Each store has a manager, a technician, and between one and four sales reps. The owners want to create a personnel records database, and they asked you to review a table that they had designed. They suggested fields for store number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones. Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?

Design an Employee database in SQL having id, name, DOB, gender, designation, department and joining_date.Using appropriate controls and design a windows form for the Employee database. Perform the CRUD operation in windows form using Entity Framework DatabaseFirst approach. Select the record from Grid view for update and delete. Also generate report of Employees using Crystal Reports. Please don't highlight it. Perform full code with it and if possible send me the db and visual studio file in zip. Thanks

Task 5:The marketing team wants to celebrate the success of StayWell with a party. The team wants a table with the names of all residents and owners combined into single column named PARTICIPANT. You need to combine this information from the tables and send it back to the team. You do not need to create a new table in the database schema. I found the answer but it wroten on paper so its really hard to understand what it is, that's why I am posting this question again.

Customer Equipment Loan id equipmentCode name id name H description RentalRatePerDay address 04 equipment Code e contact startDate dateOfBirth returnDate occupation DamageReport reportId damageType (iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. ID Name Address Contact DateOfBirth Occupation Number of Equipment Rented Total Rent NumDamage ST82J Charles Toles 23 Haig Road 92142331 15-03-1976 Teacher 20.00 S823F Damien Low 5 Still Road 88128833 05-07-1985 Teacher 1 16.00 1 3 sa56F Audrey Ng 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 1 2 Jalan Eunos 8 Jalan Melayu Ali Bin Mohd Hassan 10 Clomonti Road 91239123 4 S345G Betsey Tan 98981212 12-05-1990 Cartoonist 4.00 99234J Peter Lee 97589758 04-03-1991 Student 1 24.00 SATSZ S575J Ravi S/O Ramasamy 12 Jurong Road 6 10-07-1997 IT Programmer 0.00 7 82223333…

What is metadata, exactly? For a result set, what is metadata? Result set information might be helpful in some situations.

My current assignment is to work on a Access database for our college for clubs. Business rules are: Some students may join no clubs. Students can only join one club. There must be one student to be a club. I am having difficulties in establishing the above rules in Access. I think my relationships are incorrect. Please see attached.

Consignment shops offer a great service to our communities in that they allow us to purchase slightly used goods at very valuable prices. The original owners of these goods bring in their merchandise to selI. Upon selling the item, the consignment shop retains 25% of the sale for their services. You are working for a local shop. Every month the database, containing the sales data produces a report that details the amount sales per each original owner. Your job is to write a program that will help analyze this data. The array of sales data is as follows: owner sales = [201.45, 550.00, 117.65, 55.25, 5.95, 365.451 Your program needs to create 4 functions accomplishing the following tasks: main: This function will call all of your other functions, in the following order: Print Sales, Find Lowest and Determine Payout. It will also print the lowest sales. Print Sales: This function will print each sale. • Find Lowest: This function will find the lowest sale and print it. Determine Payout:…

A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies.   Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is…

John liked your work so much that he would like you to create a database for the comic book shop that you worked with in the first project. Create a relational database with at least two tables. Comic book and company would be two logical ones