Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Problem1. prepare the SQL code that will create ALL the tables as given in the appendix. Your answer should not contain the primary key and foreign key constraint declaration.  The data type for each attribute should be as specified in the Appendix. Assume that the tables will be associated with the dbo schema. The tables must be created on the Primary Filegroup and the table will NOT   make use of the IDENTITY feature to automatically increment the Primary Key value.

Problem2. Assuming that all the tables have been created as given in the relational schema in the Appendix, prepare SQL code to make the following changes in the structure of the tables. describe in which order the following constraint will have to be created so that the SQL Script does not generate any errors.

• Make the S_ID the Primary Key and the F_ID as the Foreign Key in the STUDENT table.

• Create a constraint in the STUDENT table for the S_CLASS column, so that it will only accept the following values: FR, JR, SR AND SO

• Make the F_ID the Primary Key and the LOC_ID as the Foreign Key in the FACULTY table.

• Create a constraint in the FACULTY table for the F_RANK column, so that it will only accept the following values: ASSO, ASST, FULL and INST

• Make the LOC_ID the Primary Key of the LOCATION table.

• Create a constraint for the F_PIN in FACULTY table, so that no two people will have the same PIN number.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95825

Have any Question? 


Related Questions in DBMS

Assignmentthis assignment requires you to design a video

Assignment This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal stra ...

Discussionatleast 1 paragraph for each partpart 1 remote

Discussion Atleast 1 paragraph for each part Part 1: "Remote Access" Please respond to the following: • Remote access to corporate resources is becoming commonplace. From an auditing perspective, suggest two or more cont ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen