Mike is a database administrator who has recently joined an online car rental company who captured and stored data in Microsoft Excel spreadsheets. He is tasked with creating a database and migrating all the data into a relational database management system. Mike wants to implement an Oracle database, but is unsure of the Oracle 11 g edition to use. Explain to Mike the various program categories that will enable him to operate a database in Oracle. Discuss at least three of these program categories.    Differentiate between Sequences and Synonyms and how they can be used to ensure better data management.

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.

T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.

Question  A city college would like to maintain their academic information in a MySql database system.  The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…

Hi for my home work can you draw a ERD digram and also convert it into a relational database schema .thanks

How to Write a sequence of SQL Statements that include a Stored Trigger to Create an Audit Trail for Updating and Deleting Rows in a Table in your version of the Sales Rep - Customer - Invoice Database. Write a Stored Trigger linked updating a table row in the  Enterprise Contracting Company Database.  Enterprise Contracting Company Database Write a Stored Trigger linked deleting a table row in the  Enterprise Contracting Company Database   For each Trigger, a copy of the row before the update or delete operation should be placed in one or more audit tables that keep track of the history of the data. Your Script must contain SQL Statements that Test and Verify that the Triggers are working correctly.   A Delete Statement removing one or more rows from a table An Update Statement changing one or more rows from a table   CREATE TABLE Statement to create your version of the audit table storing the versions of the data before being deleted or updated   SELECT Statements visually…

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