Answer:
2. A data modelling project using a packaged data model REQUIRES A GREATER SKILL than a project not using a packaged data model.
Explanation:
1a. Review of universal models:
A data model is an abstract model that organizes elements of data and standardizes how they relate to one another and to the properties of real world entities. It has become the standard approach used towards designing databases.
A universal data model is a template data model that can be reused as a starting point or a building block to jump-start development of a data modelling project, industry specific model, logical data models.
1b. Discuss how these are being used more widely today.
*Universal data models helps professional reduce development time, improve consistency and standardization while achieving high quality models.
*Higher quality: just as architects consider blue prints before constructing a building, one should also consider data before building an app. A data model helps define the problem, enabling one to consider different approaches and choose best ones.
*By properly modelling and organization's data, the database designer can eliminate data redundancies (needless repetitions) which are a key source for inaccurate information and ineffective systems.
2. Greater and advanced skills are adequate and required when data modelling project is done using packaged data model while fewer skills are required when data modelling is done without packaged data model.
Tax preparation software can help prepare and file your taxes by April 15.
Answer:
The trigger code is given below
create trigger F1_Del
after delete on Friend
for each row
when exists (select * from Friend
where ID1 = Old.ID2 and ID2 = Old.ID1)
begin
delete from Friend
where (ID1 = Old.ID2 and ID2 = Old.ID1);
end
create trigger F1_Insert
after insert on Friend
for each row
when not exists (select * from Friend
where ID1 = New.ID2 and ID2 = New.ID1)
begin
insert into Friend values (New.ID2, New.ID1);
end
Answer:
Code works perfectly
Explanation:
There is nothing wrong with your program as it runs perfectly and displays the expected results.
You may need to compile with another compiler if you're not getting the required results.
I've added the source code as an attachment (unedited)
