User Account

All Pages

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

Questions Cloud

Find which ball has positive charge : Two tiny spheres of mass 6.80 mg carry charges of equal magnitude, 72.0 nC, but opposite sign. Which ball (the one on the right or the one on the left ) has positive charge ? What is the magnitude E of the field
Find the total electric flux leaving the surface of sphere : A uniformly charged conducting sphere of 1.6 m diameter has a surface charge density of 9.9 µC/m2. What is the total electric flux leaving the surface of the sphere
Explain entity integrity and referential integrity rules : Explain entity integrity and referential integrity rules in relational model.show how these aer realized in sql
What is the melting point of this substance : A platinum resistance thermometer has resistances of 220.0 when placed in a 0°C ice bath, What is the melting point of this substance
Provide a sql script file to define the database schema : 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.
What is the diameter of the airy disk on the screen : Monochromatic light with wavelength 570nm passes through a circular aperture with diameter 7.00?m. What is the diameter of the Airy disk on the screen
Population variances of the test scores : Population variances of the test scores for the two sections are the same?  Be specific about the null and alternative hypotheses and show the steps of your test and indicate your conclusion.
Description of vulnerability, exploit and attack software : Describe the vulnerability that the attack exploits, including how or why the vulnerability exists; what versions of software are vulnerable.
What is bitcoin mining : Discuss BitCoin. What are they? Who made them? How long have they been around? What is BitCoin Mining? In your opinion, will BitCoins stick around? Why or Why Not?

Reviews

Write a Review

Database Management System Questions & Answers

  A county wishes to create a database

A county wishes to create a database to control its local libraries. Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employees and the general day-to-day management..

  Map the eer schema into a set of relations

Map the EER schema into a set of relations. For the VEHICLE to CAR/ TRUCK/ SUV generalization, consider the four options presented

  Prepare table which is in first normal form

Prepare the example of table which is in first normal form but not in second normal form and example of a table which is in second normal form but not in third normal form.

  Prove-leaves of binary search tree are located in bottom

Examples for small n are given bellow, where a small square box represents an unsuccessful search. Prove that leaves of any binary search tree are located in the bottom two levels.

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  Explain the architecture of a system for serving up

Draw a diagram of, and explain the architecture of a system for serving up dynamic pages from a database. Show the protocols involved, the flow of messages and what types of information the messages contain.

  Evaluation team in order to meet sarbanes-oxley compliance

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley compliance.

  Create a database.

Create a database.

  Create database to keep information of movies

Create a database for Ray. He is interested in movies and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce reports.

  Design scheme for determining wine bottle which poisoned

Design a scheme for determining exactly which one of the wine bottles was poisoned in just one month's time while expending O(logn) taste testers.

  Develop a new information system

MGMT321 Group Project :  You were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size organization. The proposed system will contain employees’ data and interface with the organization’s General ..

  What is the key for r

What is the key for R? Decompose R into 2NF, then 3NF relations and what you know about the relation to show that this MD cannot violate 4NF

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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