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

  Explain the security mechanisms available for a database

Use technology and information resources to research issues in database systems. Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

  Recognize business processes evaluated-dw-bi application

Identify the business processes which would be evaluated and tracked with a DW/BI application and state your reasoning or justification for including these in the DW/BI.

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Describe information using table

Describe the information seen, using the terms such as table, schema and key. Describe the EMPLOYEE and EMP_PHOTO tables in detail.

  Specify the foreign keys for schema

First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples.

  Write sql select statements to retrieve

How many models of the Titanic have been shipped? What was the date of the first shipment and when was the last shipment sent - Write SQL SELECT statements to retrieve

  Data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity.

  Design an er diagram to capture the given requirements

Design an ER diagram to capture the requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction for his client ka..

  Design and implement a small database application

Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database and develop queries in the target DBMS

  List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.

  Why triggers are significant in database systems

What are triggers used for, and why are they significant in database systems? Give an example of situation where a trigger would be appropriate. What would implementation of this trigger look like?

  What is the goal of computer forensics

From your knowledge and experience how are computer forensic investigators, in today's world of complex technology, are able to retrieve and analyze data that can be used in computer forensic investigations.

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