Provide a sql script file to define the database schema

Assignment Help Database Management System
Reference no: EM13325091

Tasks

a. Draw an ER diagram showing the manager's conceptual view of Happy Customer Garage.

b. Using Crow's Foot notation, transform the ERD into a normalised, logical, (relational) model, resolving any M:N relationships, and showing connectivity and cardinality. Add appropriate attributes to each relation and define primary and foreign keys.

c. Summarise your proposed implementation in a simple data dictionary in tabular form, showing all designer-defined objects in the database including indexes on the customer name in the CUSTOMER table and product name in the PRODUCT, a SEQUENCE to generate unique maintenance record numbers starting from 1000, and a TRIGGER that sets a flag when a part's quantity on hand falls below a designated minimum. The data dictionary should show the data types and any constraints on attributes.

d. Provide a SQL script file to define the database schema, HappyCustomerDB. Your script should be organised so that whenever the script is loaded all the database objects will be dropped and re-created.

e. Provide SQL script to insert at least several rows of data into each table.

You should zip your diagrams and scripts into a single file and submit via Stream. Your assignment will be marked by checking your diagrams against the business rules and running your scripts in Oracle 10g and evaluating the results.

 

Reference no: EM13325091

Define set of relational schemas and identify primary keys

We want to construct a database for a world-wide package delivery company. Define a set of relational schemas and identify primary and foreign keys. Try not to include redun

Draw a use case diagram to represent actors in system

A patron can reserve a book or journal that has been lent out or is in the process of purchase. The reservation should be canceled when the patron checks out the book or jou

How many of jobs want you to have some database knowledge

How many of those jobs want you to have some database knowledge?-What's your take-should you expand your education and learn more about databases and DBMSs? Why or why not?

Create naming conventions for each entity and attributes

Create naming conventions for each entity and attributes. Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationsh

Analyze the sales data to determine the true track record

You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the

List the sales for each customer

Each query is worth 2 marks. These tables exist in sphinx and are owned by the user dtoohey. You may, if you wish, create your own copies of the tables under your own accoun

Draw an erd containing the order and customer entity

Draw an ERD containing the order and customer entity types connected by a 1-M relationship from customer to order. Choose an appropriate relationship name using your common

Hotel management system database project

Hotel Management System Database Project - A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd